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_YEAR_END_EXTRACT dependencies on PAY_PAYROLLS_F

Line 255: pay_payrolls_f p,

251: -- delete all the rows for this tax_district_reference else if no
252: -- tax_district_reference specified delete all rows within the business group
253: delete from pay_gb_year_end_values v where exists (
254: select '1' from pay_gb_year_end_assignments ye_asg,
255: pay_payrolls_f p,
256: hr_soft_coding_keyflex flex,
257: hr_organization_information org
258: where p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
259: and org.ORG_INFORMATION_CONTEXT = 'Tax Details References'

Line 283: select '1' from pay_payrolls_f p,

279: -- delete all the rows in assignments for this permit , if no permit specified
280: -- delete all the rows for this tax_district_reference else if no
281: -- tax_district_reference specified delete all rows within the business group
282: delete from pay_gb_year_end_assignments ye_asg where exists (
283: select '1' from pay_payrolls_f p,
284: hr_soft_coding_keyflex flex, hr_organization_information org
285: where p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
286: and org.ORG_INFORMATION_CONTEXT = 'Tax Details References'
287: and org.org_information1 = flex.segment1

Line 308: where exists ( select '1' from pay_payrolls_f p,

304: -- delete all the rows in payrolls for this permit , if no permit specified
305: -- delete all the rows for this tax_district_reference else if no
306: -- tax_district_reference specified delete all rows within the business group
307: delete from pay_gb_year_end_payrolls ye_roll
308: where exists ( select '1' from pay_payrolls_f p,
309: hr_soft_coding_keyflex flex, hr_organization_information org
310: where p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
311: and org.ORG_INFORMATION_CONTEXT = 'Tax Details References'
312: and org.org_information1 = flex.segment1

Line 524: ,pay_payrolls_f NROLL

520: /* that had a different tax district at that date */
521: ( select nvl(max(ASS.effective_start_date),
522: fnd_date.canonical_to_date('01-01-0001'))
523: from per_assignments_f ASS
524: ,pay_payrolls_f NROLL
525: ,hr_soft_coding_keyflex FLEX
526: ,per_assignments_f PASS /* previous assignment */
527: ,pay_payrolls_f PROLL
528: ,hr_soft_coding_keyflex PFLEX

Line 527: ,pay_payrolls_f PROLL

523: from per_assignments_f ASS
524: ,pay_payrolls_f NROLL
525: ,hr_soft_coding_keyflex FLEX
526: ,per_assignments_f PASS /* previous assignment */
527: ,pay_payrolls_f PROLL
528: ,hr_soft_coding_keyflex PFLEX
529: where ASS.assignment_id = BAL_ASSACT.assignment_id
530: and NROLL.payroll_id = ASS.payroll_id
531: and ASS.effective_start_date between

Line 836: from pay_payrolls_f p,

832: substr(org.org_information7,1,9) ECON,
833: flex.segment11 * 100 SMP_RECOVERED,
834: flex.segment12 * 100 SMP_COMPENSATION,
835: flex.segment13 * 100 SSP_RECOVERED
836: from pay_payrolls_f p,
837: hr_soft_coding_keyflex flex, hr_organization_information org
838: where p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
839: and org.ORG_INFORMATION_CONTEXT = 'Tax Details References'
840: and org.org_information1 = flex.segment1

Line 972: ,pay_payrolls_f NROLL

968: ass.organization_id,
969: ass.location_id,
970: ass.people_group_id
971: from per_assignments_f ASS
972: ,pay_payrolls_f NROLL
973: ,hr_soft_coding_keyflex FLEX
974: ,per_assignments_f PASS
975: ,pay_payrolls_f PROLL
976: ,hr_soft_coding_keyflex PFLEX

Line 975: ,pay_payrolls_f PROLL

971: from per_assignments_f ASS
972: ,pay_payrolls_f NROLL
973: ,hr_soft_coding_keyflex FLEX
974: ,per_assignments_f PASS
975: ,pay_payrolls_f PROLL
976: ,hr_soft_coding_keyflex PFLEX
977: ,pay_gb_year_end_payrolls ye_roll
978: where NROLL.payroll_id = ASS.payroll_id
979: and ye_roll.payroll_id = PASS.payroll_id

Line 1031: ,pay_payrolls_f NROLL

1027: hr_utility.set_location('PAY_YEAR_END_EXTRACT.EXTRACT',16);
1028: update pay_gb_year_end_assignments ye_asg set ( effective_start_date ) =
1029: ( select max(ASS.effective_start_date)
1030: from per_assignments_f ASS
1031: ,pay_payrolls_f NROLL
1032: ,hr_soft_coding_keyflex FLEX
1033: ,per_assignments_f PASS
1034: ,pay_payrolls_f PROLL
1035: ,hr_soft_coding_keyflex PFLEX

Line 1034: ,pay_payrolls_f PROLL

1030: from per_assignments_f ASS
1031: ,pay_payrolls_f NROLL
1032: ,hr_soft_coding_keyflex FLEX
1033: ,per_assignments_f PASS
1034: ,pay_payrolls_f PROLL
1035: ,hr_soft_coding_keyflex PFLEX
1036: ,pay_gb_year_end_payrolls ye_roll
1037: where ass.assignment_id = ye_asg.assignment_id
1038: and ass.effective_start_date < ye_asg.effective_end_date