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_PAYROLLS_F

Line 1006: ROLL PAY_PAYROLLS_F_PK,

1002: /* assignment rows with its predecessor looking for the payroll */
1003: /* that had a different tax district at that date */
1004: ( select /*+ ORDERED INDEX (NASS PER_ASSIGNMENTS_F_PK,
1005: PASS PER_ASSIGNMENTS_F_PK,
1006: ROLL PAY_PAYROLLS_F_PK,
1007: FLEX HR_SOFT_CODING_KEYFLEX_PK,
1008: PROLL PAY_PAYROLLS_F_PK,
1009: PFLEX HR_SOFT_CODING_KEYFLEX_PK)
1010: USE_NL(NASS,PASS,ROLL,FLEX,PROLL,PFLEX) +*/

Line 1008: PROLL PAY_PAYROLLS_F_PK,

1004: ( select /*+ ORDERED INDEX (NASS PER_ASSIGNMENTS_F_PK,
1005: PASS PER_ASSIGNMENTS_F_PK,
1006: ROLL PAY_PAYROLLS_F_PK,
1007: FLEX HR_SOFT_CODING_KEYFLEX_PK,
1008: PROLL PAY_PAYROLLS_F_PK,
1009: PFLEX HR_SOFT_CODING_KEYFLEX_PK)
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

Line 1630: from pay_payrolls_f p,

1626: --
1627: begin
1628: select FLEX.segment1,a.person_id
1629: into l_tax_reference, l_person_id
1630: from pay_payrolls_f p,
1631: per_assignments_f a,
1632: hr_soft_coding_keyflex FLEX
1633: where a.assignment_id = p_assignment_id
1634: and a.payroll_id = p.payroll_id

Line 1648: from pay_payrolls_f p,

1644: -- check how many period types you have for this person excluding those
1645: -- reported and calculated under a different tax reference
1646: begin
1647: select count(distinct ptpt.NUMBER_PER_FISCAL_YEAR) into l_count
1648: from pay_payrolls_f p,
1649: per_assignments_f a,
1650: hr_soft_coding_keyflex FLEX,
1651: per_time_period_types ptpt
1652: where a.person_id = l_person_id

Line 1709: index(p pay_payrolls_f_pk)

1705: /*+
1706: ordered
1707: use_nl(a p flex)
1708: index(a per_assignments_f_pk)
1709: index(p pay_payrolls_f_pk)
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,

Line 1734: index(p pay_payrolls_f_pk)

1730: /*+
1731: ordered
1732: use_nl(a p flex ptpt)
1733: index(a per_assignments_f_n12)
1734: index(p pay_payrolls_f_pk)
1735: index(flex hr_soft_coding_keyflex_pk)
1736: index(ptpt per_time_period_types_pk)
1737: */
1738: min(ptpt.NUMBER_PER_FISCAL_YEAR) into l_freq

Line 2115: ROLL PAY_PAYROLLS_F_PK,

2111: /* assignment rows with its predecessor looking for the payroll */
2112: /* that had a different tax district at that date */
2113: ( select /*+ ORDERED INDEX (NASS PER_ASSIGNMENTS_F_PK,
2114: PASS PER_ASSIGNMENTS_F_PK,
2115: ROLL PAY_PAYROLLS_F_PK,
2116: FLEX HR_SOFT_CODING_KEYFLEX_PK,
2117: PROLL PAY_PAYROLLS_F_PK,
2118: PFLEX HR_SOFT_CODING_KEYFLEX_PK)
2119: USE_NL(NASS,PASS,ROLL,FLEX,PROLL,PFLEX) +*/

Line 2117: PROLL PAY_PAYROLLS_F_PK,

2113: ( select /*+ ORDERED INDEX (NASS PER_ASSIGNMENTS_F_PK,
2114: PASS PER_ASSIGNMENTS_F_PK,
2115: ROLL PAY_PAYROLLS_F_PK,
2116: FLEX HR_SOFT_CODING_KEYFLEX_PK,
2117: PROLL PAY_PAYROLLS_F_PK,
2118: PFLEX HR_SOFT_CODING_KEYFLEX_PK)
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