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 1014: ,pay_all_payrolls_f ROLL

1010: USE_NL(NASS,PASS,ROLL,FLEX,PROLL,PFLEX) +*/
1011: nvl(max(NASS.effective_start_date), to_date('01-01-0001','DD-MM-YYYY'))
1012: from per_all_assignments_f NASS
1013: ,per_all_assignments_f PASS
1014: ,pay_all_payrolls_f ROLL
1015: ,hr_soft_coding_keyflex FLEX
1016: ,pay_all_payrolls_f PROLL
1017: ,hr_soft_coding_keyflex PFLEX
1018: where NASS.assignment_id = ASS.assignment_id

Line 1016: ,pay_all_payrolls_f PROLL

1012: from per_all_assignments_f NASS
1013: ,per_all_assignments_f PASS
1014: ,pay_all_payrolls_f ROLL
1015: ,hr_soft_coding_keyflex FLEX
1016: ,pay_all_payrolls_f PROLL
1017: ,hr_soft_coding_keyflex PFLEX
1018: where NASS.assignment_id = ASS.assignment_id
1019: and ROLL.payroll_id = NASS.payroll_id
1020: and NASS.effective_start_date between

Line 1035: pay_all_payrolls_f BROLL

1031: and FLEX.segment1 <> PFLEX.segment1
1032: )
1033: and exists ( select null from
1034: /* check that the current assignment tax districts match */
1035: pay_all_payrolls_f BROLL
1036: ,hr_soft_coding_keyflex BFLEX
1037: ,pay_all_payrolls_f PROLL
1038: ,hr_soft_coding_keyflex PFLEX
1039: where BACT.payroll_id = BROLL.payroll_id

Line 1037: ,pay_all_payrolls_f PROLL

1033: and exists ( select null from
1034: /* check that the current assignment tax districts match */
1035: pay_all_payrolls_f BROLL
1036: ,hr_soft_coding_keyflex BFLEX
1037: ,pay_all_payrolls_f PROLL
1038: ,hr_soft_coding_keyflex PFLEX
1039: where BACT.payroll_id = BROLL.payroll_id
1040: and PACT.payroll_id = PROLL.payroll_id
1041: and BFLEX.soft_coding_keyflex_id = BROLL.soft_coding_keyflex_id

Line 1714: pay_all_payrolls_f p,

1710: index(flex hr_soft_coding_keyflex_pk)
1711: */
1712: FLEX.segment1,a.person_id into l_tax_reference, l_person_id
1713: from per_all_assignments_f a,
1714: pay_all_payrolls_f p,
1715: hr_soft_coding_keyflex FLEX
1716: where a.assignment_id = l_assignment_id
1717: and a.payroll_id = p.payroll_id
1718: and l_effective_date between a.effective_start_date and a.effective_end_date

Line 1740: pay_all_payrolls_f p,

1736: index(ptpt per_time_period_types_pk)
1737: */
1738: min(ptpt.NUMBER_PER_FISCAL_YEAR) into l_freq
1739: from per_all_assignments_f a,
1740: pay_all_payrolls_f p,
1741: hr_soft_coding_keyflex FLEX,
1742: per_time_period_types ptpt
1743: where a.person_id = l_person_id
1744: and a.payroll_id = p.payroll_id

Line 2123: ,pay_all_payrolls_f ROLL

2119: USE_NL(NASS,PASS,ROLL,FLEX,PROLL,PFLEX) +*/
2120: nvl(max(NASS.effective_start_date), to_date('01-01-0001','DD-MM-YYYY'))
2121: from per_all_assignments_f NASS
2122: ,per_all_assignments_f PASS
2123: ,pay_all_payrolls_f ROLL
2124: ,hr_soft_coding_keyflex FLEX
2125: ,pay_all_payrolls_f PROLL
2126: ,hr_soft_coding_keyflex PFLEX
2127: where NASS.assignment_id = ASS.assignment_id

Line 2125: ,pay_all_payrolls_f PROLL

2121: from per_all_assignments_f NASS
2122: ,per_all_assignments_f PASS
2123: ,pay_all_payrolls_f ROLL
2124: ,hr_soft_coding_keyflex FLEX
2125: ,pay_all_payrolls_f PROLL
2126: ,hr_soft_coding_keyflex PFLEX
2127: where NASS.assignment_id = ASS.assignment_id
2128: and ROLL.payroll_id = NASS.payroll_id
2129: and NASS.effective_start_date between

Line 2144: pay_all_payrolls_f BROLL

2140: and FLEX.segment1 <> PFLEX.segment1
2141: )
2142: and exists ( select null from
2143: /* check that the current assignment tax districts match */
2144: pay_all_payrolls_f BROLL
2145: ,hr_soft_coding_keyflex BFLEX
2146: ,pay_all_payrolls_f PROLL
2147: ,hr_soft_coding_keyflex PFLEX
2148: where BACT.payroll_id = BROLL.payroll_id

Line 2146: ,pay_all_payrolls_f PROLL

2142: and exists ( select null from
2143: /* check that the current assignment tax districts match */
2144: pay_all_payrolls_f BROLL
2145: ,hr_soft_coding_keyflex BFLEX
2146: ,pay_all_payrolls_f PROLL
2147: ,hr_soft_coding_keyflex PFLEX
2148: where BACT.payroll_id = BROLL.payroll_id
2149: and PACT.payroll_id = PROLL.payroll_id
2150: and BFLEX.soft_coding_keyflex_id = BROLL.soft_coding_keyflex_id