eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IE_P45PART3_P46_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 368: l_assignment_number per_all_assignments_f.assignment_number%type;

364: chunk in number)
365: IS
366: l_assg_id per_assignments_f.assignment_id%TYPE;
367: l_person_id Number;
368: l_assignment_number per_all_assignments_f.assignment_number%type;
369: l_period_of_service_id per_all_assignments_f.period_of_service_id%type;
370:
371: l_prev_person_id Number := 0;
372: l_prev_period_of_service_id per_all_assignments_f.period_of_service_id%type := 0;

Line 369: l_period_of_service_id per_all_assignments_f.period_of_service_id%type;

365: IS
366: l_assg_id per_assignments_f.assignment_id%TYPE;
367: l_person_id Number;
368: l_assignment_number per_all_assignments_f.assignment_number%type;
369: l_period_of_service_id per_all_assignments_f.period_of_service_id%type;
370:
371: l_prev_person_id Number := 0;
372: l_prev_period_of_service_id per_all_assignments_f.period_of_service_id%type := 0;
373:

Line 372: l_prev_period_of_service_id per_all_assignments_f.period_of_service_id%type := 0;

368: l_assignment_number per_all_assignments_f.assignment_number%type;
369: l_period_of_service_id per_all_assignments_f.period_of_service_id%type;
370:
371: l_prev_person_id Number := 0;
372: l_prev_period_of_service_id per_all_assignments_f.period_of_service_id%type := 0;
373:
374: l_start_date VARCHAR2(50);
375: l_end_date VARCHAR2(50);
376: l_select_str VARCHAR2(3000);

Line 392: per_all_assignments_f paa

388: FROM pay_element_types_f pet,
389: pay_input_values_f piv,
390: pay_element_entries_f pee,
391: pay_element_entry_values_f peev,
392: per_all_assignments_f paa
393: WHERE pet.element_name='IE P45P3_P46 Information'
394: AND piv.name='P45P3 Or P46 Processed'
395: AND pet.element_type_id=piv.element_type_id
396: AND paa.assignment_id=p_assg_id

Line 448: from per_all_assignments_f paa

444: --and peev.screen_entry_value=g_file_type_v;
445: --to check wheteher the employee has an assg with the paye ref before
446: /* CURSOR csr_ass_check (c_assignment_id IN Number, p_person_id IN Number) IS
447: select 'X'
448: from per_all_assignments_f paa
449: where paa.assignment_id=c_assignment_id
450: and not exists
451: (select 1
452: from per_all_assignments_f paaf, pay_all_payrolls_f papf, hr_soft_coding_keyflex scl

Line 452: from per_all_assignments_f paaf, pay_all_payrolls_f papf, hr_soft_coding_keyflex scl

448: from per_all_assignments_f paa
449: where paa.assignment_id=c_assignment_id
450: and not exists
451: (select 1
452: from per_all_assignments_f paaf, pay_all_payrolls_f papf, hr_soft_coding_keyflex scl
453: where paaf.person_id=paa.person_id
454: and paaf.effective_start_date < paa.effective_start_date
455: and paaf.effective_end_date > g_end_date
456: and paaf.organization_id=paa.organization_id

Line 488: per_all_assignments_f paaf,

484: hr_utility.set_location('report start date= '||g_start_date,300);
485:
486: -- Query to fetch assignment_id.
487: /*l_select_str := 'select distinct paaf.assignment_id, ppf.person_id from
488: per_all_assignments_f paaf,
489: per_all_people_f ppf,
490: pay_all_payrolls_f papf,
491: pay_payroll_actions ppa,
492: hr_soft_coding_keyflex scl

Line 510: per_all_assignments_f paaf,

506:
507: -- Query to fetch assignment_id.
508: l_select_str := 'select distinct paaf.assignment_id asgid, ppf.person_id perid, pps.period_of_service_id, paaf.assignment_number
509: from
510: per_all_assignments_f paaf,
511: per_all_people_f ppf,
512: pay_all_payrolls_f papf,
513: pay_payroll_actions ppa,
514: hr_soft_coding_keyflex scl,

Line 802: per_all_assignments_f paa,

798: FROM pay_element_types_f pet,
799: pay_input_values_f piv,
800: pay_element_entries_f pee,
801: pay_element_entry_values_f peev,
802: per_all_assignments_f paa,
803: pay_assignment_actions paac
804: WHERE pet.element_name in ('IE P45P3_P46 Information','IE P45 Information')
805: --AND piv.name='P45P3 Or P46 Processed'
806: AND pet.element_type_id=piv.element_type_id

Line 837: per_all_assignments_f paa,

833: ,pa.country
834: -- Bug# 7005067
835: FROM per_all_people_f ppf,
836: per_addresses pa,
837: per_all_assignments_f paa,
838: pay_all_payrolls_f pap,
839: pay_assignment_actions ppaa,
840: pa_country_v pc, -- Bug# 7005067
841: fnd_lookup_values flv -- Bug# 7005067

Line 858: from per_all_assignments_f paa1

854: AND flv.lookup_code(+) = pa.region_1 -- Bug# 7005067
855: AND ppf.effective_start_date between pa.date_from(+) and nvl(pa.date_to, p_effective_date)
856: AND paa.effective_start_date between ppf.effective_start_date and ppf.effective_end_date
857: AND paa.effective_start_date = (select min(paa1.effective_start_date)
858: from per_all_assignments_f paa1
859: where paa1.assignment_id = paa.assignment_id
860: and paa1.effective_start_date between g_start_date and g_end_date );
861:
862: TYPE r_get_assg_detail IS RECORD (i_name pay_input_values_f.name%type,

Line 872: per_all_assignments_f paa,

868: from pay_element_types_f pet,
869: pay_input_values_f piv,
870: pay_element_entries_f pee,
871: pay_element_entry_values_f peev,
872: per_all_assignments_f paa,
873: pay_assignment_actions paac
874: WHERE pet.element_name = 'IE P45P3_P46 Information'
875: AND piv.name='P45P3 Or P46 Processed'
876: AND pet.element_type_id=piv.element_type_id