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 365: l_assignment_number per_all_assignments_f.assignment_number%type;

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

Line 366: l_period_of_service_id per_all_assignments_f.period_of_service_id%type;

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

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

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

Line 389: per_all_assignments_f paa

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

Line 445: from per_all_assignments_f paa

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

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

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

Line 485: per_all_assignments_f paaf,

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

Line 507: per_all_assignments_f paaf,

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

Line 799: per_all_assignments_f paa,

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

Line 834: per_all_assignments_f paa,

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

Line 855: from per_all_assignments_f paa1

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

Line 869: per_all_assignments_f paa,

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