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 HR_SOFT_CODING_KEYFLEX

Line 1007: FLEX HR_SOFT_CODING_KEYFLEX_PK,

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) +*/
1011: nvl(max(NASS.effective_start_date), to_date('01-01-0001','DD-MM-YYYY'))

Line 1009: PFLEX HR_SOFT_CODING_KEYFLEX_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
1013: ,per_all_assignments_f PASS

Line 1015: ,hr_soft_coding_keyflex FLEX

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
1019: and ROLL.payroll_id = NASS.payroll_id

Line 1017: ,hr_soft_coding_keyflex PFLEX

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
1021: ROLL.effective_start_date and ROLL.effective_end_date

Line 1036: ,hr_soft_coding_keyflex BFLEX

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
1040: and PACT.payroll_id = PROLL.payroll_id

Line 1038: ,hr_soft_coding_keyflex PFLEX

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
1042: and PFLEX.soft_coding_keyflex_id = PROLL.soft_coding_keyflex_id

Line 1632: hr_soft_coding_keyflex FLEX

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
1635: and l_effective_date
1636: between a.effective_start_date and a.effective_end_date

Line 1650: hr_soft_coding_keyflex FLEX,

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
1653: and a.assignment_type = 'E'
1654: and a.payroll_id = p.payroll_id

Line 1710: index(flex hr_soft_coding_keyflex_pk)

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,
1714: pay_all_payrolls_f p,

Line 1715: hr_soft_coding_keyflex FLEX

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
1719: and l_effective_date between p.effective_start_date and p.effective_end_date

Line 1735: index(flex hr_soft_coding_keyflex_pk)

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
1739: from per_all_assignments_f a,

Line 1741: hr_soft_coding_keyflex FLEX,

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
1745: /*Bug 13829747-- Added a check to pick only assignments which are of employee type*/

Line 2116: FLEX HR_SOFT_CODING_KEYFLEX_PK,

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) +*/
2120: nvl(max(NASS.effective_start_date), to_date('01-01-0001','DD-MM-YYYY'))

Line 2118: PFLEX HR_SOFT_CODING_KEYFLEX_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
2122: ,per_all_assignments_f PASS

Line 2124: ,hr_soft_coding_keyflex FLEX

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
2128: and ROLL.payroll_id = NASS.payroll_id

Line 2126: ,hr_soft_coding_keyflex PFLEX

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
2130: ROLL.effective_start_date and ROLL.effective_end_date

Line 2145: ,hr_soft_coding_keyflex BFLEX

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
2149: and PACT.payroll_id = PROLL.payroll_id

Line 2147: ,hr_soft_coding_keyflex PFLEX

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
2151: and PFLEX.soft_coding_keyflex_id = PROLL.soft_coding_keyflex_id