DBA Data[Home] [Help]

APPS.PQH_PTX_UTL dependencies on PQH_PTX_SHADOW

Line 424: insert into pqh_ptx_shadow

420: open c2;
421: fetch c2 into rec2;
422: close c2;
423:
424: insert into pqh_ptx_shadow
425: (
426: AMENDMENT_DATE,
427: AMENDMENT_RECOMMENDATION,
428: AMENDMENT_REF_NUMBER,

Line 2961: from pqh_ptx_shadow

2957: from pqh_position_transactions
2958: where position_transaction_id = p_position_transaction_id
2959: and position_transaction_id not in
2960: (select position_transaction_id
2961: from pqh_ptx_shadow
2962: where position_transaction_id = p_position_transaction_id);
2963: rec1 c1%rowtype;
2964: begin
2965: open c1;

Line 2970: insert into pqh_ptx_shadow

2966: fetch c1 into rec1;
2967: if c1%notfound then
2968: return;
2969: end if;
2970: insert into pqh_ptx_shadow
2971: (position_transaction_id, action_date, position_id, availability_status_id, business_group_id, entry_grade_id,
2972: entry_step_id, entry_grade_rule_id, job_id, location_id, organization_id, pay_basis_id, pay_freq_payroll_id,
2973: position_definition_id, prior_position_id, relief_position_id, successor_position_id, supervisor_id,
2974: supervisor_position_id, amendment_date, amendment_recommendation, amendment_ref_number, avail_status_prop_end_date,