APPS.HR_DELTA_SYNC_MESSAGES dependencies on HR_PYRL_DELTA_SYNC

Line 2654: from hr_pyrl_delta_sync pyrl

2650: from pay_all_payrolls_f pay
2651: where last_update_date > p_max_run_date
2652: and p_effective_date between effective_start_date and effective_end_date
2653: and (payroll_id,business_group_id) not in (select pyrl.payroll_id,pyrl.business_group_id
2654: from hr_pyrl_delta_sync pyrl
2655: where pay.payroll_id = pyrl.payroll_id
2656: and pay.business_group_id = pyrl.business_group_id
2657: and pay.last_update_date <= pyrl.last_update_date
2658: and pyrl.status in ('QUEUED','SENT'));

Line 2668: hr_pyrl_delta_sync

2664:
2665: cursor fet_delta_status
2666: is
2667: select payroll_id,business_group_id,event_key,last_update_date from
2668: hr_pyrl_delta_sync
2669: where status = 'QUEUED';
2670:
2671: p_payroll_id number(9,0);
2672: p_bgrp_id NUMBER(15,0);

Line 2749: update hr_pyrl_delta_sync

2745: fetch fet_delta_status into p_payroll_id,p_bgrp_id,p_event_key_gen,p_lstupd_date;
2746:
2747: if fet_delta_status%found then
2748:
2749: update hr_pyrl_delta_sync
2750: set status = 'SENT'
2751: where event_key = p_event_key_gen;
2752: commit;
2753:

Line 2759: insert into hr_pyrl_delta_sync(PAYROLL_ID,

2755: fetch fet_pyrl_sync into p_pyrl_id,p_pyrl_name,p_bg_id,p_eff_date,p_eff_status,p_last_update_date;
2756: if fet_pyrl_sync%found then
2757:
2758: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
2759: insert into hr_pyrl_delta_sync(PAYROLL_ID,
2760: PAYROLL_NAME,
2761: BUSINESS_GROUP_ID ,
2762: EFFECTIVE_DATE,
2763: EFFECTIVE_STATUS ,

Line 2808: insert into hr_pyrl_delta_sync(PAYROLL_ID,

2804: loop
2805: fetch fet_pyrl_fsync into p_pyrl_id,p_pyrl_name,p_bg_id,p_eff_date,p_eff_status,p_last_update_date;
2806: if fet_pyrl_fsync%found then
2807: select hrhd_delta_sync_seq.nextval into p_unique_key from dual;
2808: insert into hr_pyrl_delta_sync(PAYROLL_ID,
2809: PAYROLL_NAME,
2810: BUSINESS_GROUP_ID ,
2811: EFFECTIVE_DATE,
2812: EFFECTIVE_STATUS ,

Line 2961: update hr_pyrl_delta_sync

2957: where event_key = p_event_key;
2958:
2959: elsif p_process_name = 'PAYROLL_DELTA_SYNCH' then
2960:
2961: update hr_pyrl_delta_sync
2962: set status = 'SENT'
2963: where event_key = p_event_key;
2964:
2965: end if;