APPS.PQH_PTX_UTL dependencies on PQH_TJR_SHADOW

Line 933: (select null from pqh_tjr_shadow pts

929: select *
930: from per_job_requirements pjr
931: where pjr.position_id = p_position_id
932: and not exists
933: (select null from pqh_tjr_shadow pts
934: where pts.position_transaction_id = p_position_transaction_id
935: and pts.job_requirement_id = pjr.job_requirement_id);
936:
937: --

Line 3099: from pqh_tjr_shadow

3095: where position_transaction_id = p_position_transaction_id
3096: and job_requirement_id is not null
3097: and txn_job_requirement_id not in
3098: (select txn_job_requirement_id
3099: from pqh_tjr_shadow
3100: where position_transaction_id = p_position_transaction_id);
3101: begin
3102: for rec3 in c3 loop
3103: insert into pqh_tjr_shadow (

Line 3103: insert into pqh_tjr_shadow (

3099: from pqh_tjr_shadow
3100: where position_transaction_id = p_position_transaction_id);
3101: begin
3102: for rec3 in c3 loop
3103: insert into pqh_tjr_shadow (
3104: txn_job_requirement_id, position_transaction_id, job_requirement_id,
3105: business_group_id, analysis_criteria_id, date_from, date_to,
3106: essential, job_id, object_version_number,
3107: attribute_category, attribute1, attribute2, attribute3,

Line 3229: from per_job_requirements jreq,pqh_tjr_shadow pts

3225: l_object_version_number number;
3226:
3227: CURSOR c_del_tjr(p_transaction_id number, p_position_id number) IS
3228: select jreq.job_requirement_id, jreq.object_version_number
3229: from per_job_requirements jreq,pqh_tjr_shadow pts
3230: where position_id = p_position_id
3231: and jreq.job_requirement_id = pts.job_requirement_id
3232: and pts.position_transaction_id = p_transaction_id
3233: and not exists (

Line 3245: from pqh_tjr_shadow

3241: from pqh_txn_job_requirements
3242: where position_transaction_id = p_position_transaction_id;
3243: cursor c_pes(p_txn_job_requirement_id number) is
3244: select *
3245: from pqh_tjr_shadow
3246: where txn_job_requirement_id = p_txn_job_requirement_id;
3247: CURSOR c5 (p_position_id in hr_all_positions_f.position_id%TYPE,
3248: -- p_information_type in per_position_extra_info.information_type%type,
3249: p_job_requirement_id in

Line 3449: from pqh_txn_job_requirements tjr, pqh_tjr_shadow pts

3445: );
3446: --
3447: cursor c_prs_tjr(p_position_transaction_id number, p_position_id number) is
3448: select tjr.txn_job_requirement_id, tjr.object_version_number
3449: from pqh_txn_job_requirements tjr, pqh_tjr_shadow pts
3450: where tjr.txn_job_requirement_id = pts.txn_job_requirement_id
3451: and tjr.position_transaction_id = pts.position_transaction_id
3452: and tjr.position_transaction_id = p_position_transaction_id
3453: and not exists

Line 3493: delete pqh_tjr_shadow

3489: --
3490: delete pqh_txn_job_requirements
3491: where txn_job_requirement_id = r_prs_tjr.txn_job_requirement_id;
3492: --
3493: delete pqh_tjr_shadow
3494: where txn_job_requirement_id = r_prs_tjr.txn_job_requirement_id;
3495: end if;
3496: end loop;
3497: --