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.HR_GBNIDIR dependencies on PAY_ALL_PAYROLLS_F

Line 938: ,pay_all_payrolls_f ROLL

934: USE_NL(NASS,PASS,ROLL,FLEX,PROLL,PFLEX) +*/
935: nvl(max(NASS.effective_start_date), to_date('01-01-0001','DD-MM-YYYY'))
936: from per_all_assignments_f NASS
937: ,per_all_assignments_f PASS
938: ,pay_all_payrolls_f ROLL
939: ,hr_soft_coding_keyflex FLEX
940: ,pay_all_payrolls_f PROLL
941: ,hr_soft_coding_keyflex PFLEX
942: where NASS.assignment_id = ASS.assignment_id

Line 940: ,pay_all_payrolls_f PROLL

936: from per_all_assignments_f NASS
937: ,per_all_assignments_f PASS
938: ,pay_all_payrolls_f ROLL
939: ,hr_soft_coding_keyflex FLEX
940: ,pay_all_payrolls_f PROLL
941: ,hr_soft_coding_keyflex PFLEX
942: where NASS.assignment_id = ASS.assignment_id
943: and ROLL.payroll_id = NASS.payroll_id
944: and NASS.effective_start_date between

Line 959: pay_all_payrolls_f BROLL

955: and FLEX.segment1 <> PFLEX.segment1
956: )
957: and exists ( select null from
958: /* check that the current assignment tax districts match */
959: pay_all_payrolls_f BROLL
960: ,hr_soft_coding_keyflex BFLEX
961: ,pay_all_payrolls_f PROLL
962: ,hr_soft_coding_keyflex PFLEX
963: where BACT.payroll_id = BROLL.payroll_id

Line 961: ,pay_all_payrolls_f PROLL

957: and exists ( select null from
958: /* check that the current assignment tax districts match */
959: pay_all_payrolls_f BROLL
960: ,hr_soft_coding_keyflex BFLEX
961: ,pay_all_payrolls_f PROLL
962: ,hr_soft_coding_keyflex PFLEX
963: where BACT.payroll_id = BROLL.payroll_id
964: and PACT.payroll_id = PROLL.payroll_id
965: and BFLEX.soft_coding_keyflex_id = BROLL.soft_coding_keyflex_id

Line 1600: pay_all_payrolls_f p,

1596: index(flex hr_soft_coding_keyflex_pk)
1597: */
1598: FLEX.segment1,a.person_id into l_tax_reference, l_person_id
1599: from per_all_assignments_f a,
1600: pay_all_payrolls_f p,
1601: hr_soft_coding_keyflex FLEX
1602: where a.assignment_id = l_assignment_id
1603: and a.payroll_id = p.payroll_id
1604: and l_effective_date between a.effective_start_date and a.effective_end_date

Line 1626: pay_all_payrolls_f p,

1622: index(ptpt per_time_period_types_pk)
1623: */
1624: min(ptpt.NUMBER_PER_FISCAL_YEAR) into l_freq
1625: from per_all_assignments_f a,
1626: pay_all_payrolls_f p,
1627: hr_soft_coding_keyflex FLEX,
1628: per_time_period_types ptpt
1629: where a.person_id = l_person_id
1630: and a.payroll_id = p.payroll_id

Line 2007: ,pay_all_payrolls_f ROLL

2003: USE_NL(NASS,PASS,ROLL,FLEX,PROLL,PFLEX) +*/
2004: nvl(max(NASS.effective_start_date), to_date('01-01-0001','DD-MM-YYYY'))
2005: from per_all_assignments_f NASS
2006: ,per_all_assignments_f PASS
2007: ,pay_all_payrolls_f ROLL
2008: ,hr_soft_coding_keyflex FLEX
2009: ,pay_all_payrolls_f PROLL
2010: ,hr_soft_coding_keyflex PFLEX
2011: where NASS.assignment_id = ASS.assignment_id

Line 2009: ,pay_all_payrolls_f PROLL

2005: from per_all_assignments_f NASS
2006: ,per_all_assignments_f PASS
2007: ,pay_all_payrolls_f ROLL
2008: ,hr_soft_coding_keyflex FLEX
2009: ,pay_all_payrolls_f PROLL
2010: ,hr_soft_coding_keyflex PFLEX
2011: where NASS.assignment_id = ASS.assignment_id
2012: and ROLL.payroll_id = NASS.payroll_id
2013: and NASS.effective_start_date between

Line 2028: pay_all_payrolls_f BROLL

2024: and FLEX.segment1 <> PFLEX.segment1
2025: )
2026: and exists ( select null from
2027: /* check that the current assignment tax districts match */
2028: pay_all_payrolls_f BROLL
2029: ,hr_soft_coding_keyflex BFLEX
2030: ,pay_all_payrolls_f PROLL
2031: ,hr_soft_coding_keyflex PFLEX
2032: where BACT.payroll_id = BROLL.payroll_id

Line 2030: ,pay_all_payrolls_f PROLL

2026: and exists ( select null from
2027: /* check that the current assignment tax districts match */
2028: pay_all_payrolls_f BROLL
2029: ,hr_soft_coding_keyflex BFLEX
2030: ,pay_all_payrolls_f PROLL
2031: ,hr_soft_coding_keyflex PFLEX
2032: where BACT.payroll_id = BROLL.payroll_id
2033: and PACT.payroll_id = PROLL.payroll_id
2034: and BFLEX.soft_coding_keyflex_id = BROLL.soft_coding_keyflex_id