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 930: ROLL PAY_PAYROLLS_F_PK,

926: /* assignment rows with its predecessor looking for the payroll */
927: /* that had a different tax district at that date */
928: ( select /*+ ORDERED INDEX (NASS PER_ASSIGNMENTS_F_PK,
929: PASS PER_ASSIGNMENTS_F_PK,
930: ROLL PAY_PAYROLLS_F_PK,
931: FLEX HR_SOFT_CODING_KEYFLEX_PK,
932: PROLL PAY_PAYROLLS_F_PK,
933: PFLEX HR_SOFT_CODING_KEYFLEX_PK)
934: USE_NL(NASS,PASS,ROLL,FLEX,PROLL,PFLEX) +*/

Line 932: PROLL PAY_PAYROLLS_F_PK,

928: ( select /*+ ORDERED INDEX (NASS PER_ASSIGNMENTS_F_PK,
929: PASS PER_ASSIGNMENTS_F_PK,
930: ROLL PAY_PAYROLLS_F_PK,
931: FLEX HR_SOFT_CODING_KEYFLEX_PK,
932: PROLL PAY_PAYROLLS_F_PK,
933: PFLEX HR_SOFT_CODING_KEYFLEX_PK)
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

Line 1516: from pay_payrolls_f p,

1512: --
1513: begin
1514: select FLEX.segment1,a.person_id
1515: into l_tax_reference, l_person_id
1516: from pay_payrolls_f p,
1517: per_assignments_f a,
1518: hr_soft_coding_keyflex FLEX
1519: where a.assignment_id = p_assignment_id
1520: and a.payroll_id = p.payroll_id

Line 1534: from pay_payrolls_f p,

1530: -- check how many period types you have for this person excluding those
1531: -- reported and calculated under a different tax reference
1532: begin
1533: select count(distinct ptpt.NUMBER_PER_FISCAL_YEAR) into l_count
1534: from pay_payrolls_f p,
1535: per_assignments_f a,
1536: hr_soft_coding_keyflex FLEX,
1537: per_time_period_types ptpt
1538: where a.person_id = l_person_id

Line 1595: index(p pay_payrolls_f_pk)

1591: /*+
1592: ordered
1593: use_nl(a p flex)
1594: index(a per_assignments_f_pk)
1595: index(p pay_payrolls_f_pk)
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,

Line 1620: index(p pay_payrolls_f_pk)

1616: /*+
1617: ordered
1618: use_nl(a p flex ptpt)
1619: index(a per_assignments_f_n12)
1620: index(p pay_payrolls_f_pk)
1621: index(flex hr_soft_coding_keyflex_pk)
1622: index(ptpt per_time_period_types_pk)
1623: */
1624: min(ptpt.NUMBER_PER_FISCAL_YEAR) into l_freq

Line 1999: ROLL PAY_PAYROLLS_F_PK,

1995: /* assignment rows with its predecessor looking for the payroll */
1996: /* that had a different tax district at that date */
1997: ( select /*+ ORDERED INDEX (NASS PER_ASSIGNMENTS_F_PK,
1998: PASS PER_ASSIGNMENTS_F_PK,
1999: ROLL PAY_PAYROLLS_F_PK,
2000: FLEX HR_SOFT_CODING_KEYFLEX_PK,
2001: PROLL PAY_PAYROLLS_F_PK,
2002: PFLEX HR_SOFT_CODING_KEYFLEX_PK)
2003: USE_NL(NASS,PASS,ROLL,FLEX,PROLL,PFLEX) +*/

Line 2001: PROLL PAY_PAYROLLS_F_PK,

1997: ( select /*+ ORDERED INDEX (NASS PER_ASSIGNMENTS_F_PK,
1998: PASS PER_ASSIGNMENTS_F_PK,
1999: ROLL PAY_PAYROLLS_F_PK,
2000: FLEX HR_SOFT_CODING_KEYFLEX_PK,
2001: PROLL PAY_PAYROLLS_F_PK,
2002: PFLEX HR_SOFT_CODING_KEYFLEX_PK)
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