[Home] [Help]
378:
379: l_proc varchar2(80) := gv_package||'check_final_notifier';
380: lv_contact_source VARCHAR2(50);
381: ln_transaction_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;
382: ln_current_assignment_id per_assignments_f.assignment_id%TYPE;
383: lv_contact_user_name VARCHAR2(150);
384: ln_contact_person_id per_people_f.person_id%TYPE;
385: ln_employee_person_id per_people_f.person_id%TYPE;
386:
388:
389: CURSOR c_payroll_contact IS
390: select /*+ ordered */ prl.prl_information1 --Bug 3362223
391: from pay_stat_trans_audit pta
392: ,per_assignments_f paf
393: ,pay_payrolls_f prl
394: where prl.payroll_id = paf.payroll_id
395: and prl.prl_information_category = 'US'
396: and paf.assignment_id = pta.assignment_id
412: where org.org_information_context || '' = 'Contact Information'
413: and org.organization_id =
414: (select /*+ ordered */ hsc.segment1 --Bug 3362223
415: from pay_stat_trans_audit pta
416: ,per_assignments_f paf
417: ,hr_soft_coding_keyflex hsc
418: where hsc.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
419: and paf.assignment_id = pta.assignment_id
420: and pta.source4 = ln_transaction_id
425: and paf.effective_end_date);
426: /*
427: select org.org_information1
428: from hr_organization_information org
429: ,per_assignments_f paf
430: ,pay_stat_trans_audit pta
431: ,hr_soft_coding_keyflex hsc
432: where org.organization_id = hsc.segment1
433: and hsc.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
553: IS
554:
555: l_proc varchar2(61) := gv_package||'get_next_payroll_notifer';
556: ln_transaction_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;
557: ln_current_assignment_id per_assignments_f.assignment_id%TYPE;
558: lv_contact_source VARCHAR2(50);
559: lv_curr_contact_user VARCHAR2(100);
560: lv_next_contact_user VARCHAR2(100);
561: lv_dummy VARCHAR2(100);
565: CURSOR c_payroll_contact IS
566: select /*+ ordered */ usr.employee_id --Bug 3362223
567: ,pta.assignment_id
568: from pay_stat_trans_audit pta
569: ,per_assignments_f paf
570: ,pay_payrolls_f prl
571: ,fnd_user usr
572: where prl.payroll_id = paf.payroll_id
573: and usr.user_name = prl.prl_information1
595: and pta.source4_type = 'TRANSACTION_ID'
596: and pta.transaction_parent_id is null
597: and org.org_information_context ||'' = 'Contact Information'
598: and org.organization_id = (select hsc.segment1
599: from per_assignments_f paf
600: ,hr_soft_coding_keyflex hsc
601: where paf.assignment_id = ln_current_assignment_id
602: and hsc.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
603: and pta.transaction_effective_date