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 PER_ASSIGNMENTS_F

Line 926: START_ASS PER_ASSIGNMENTS_F_PK,

922: OR g_assignment_action_id is null then
923: select /*+ ORDERED INDEX(BAL_ASSACT PAY_ASSIGNMENT_ACTIONS_PK,
924: BACT PAY_PAYROLL_ACTIONS_PK,
925: BPTP PER_TIME_PERIODS_PK,
926: START_ASS PER_ASSIGNMENTS_F_PK,
927: ASS PER_ASSIGNMENTS_F_N12,
928: ASSACT PAY_ASSIGNMENT_ACTIONS_N51,
929: PACT PAY_PAYROLL_ACTIONS_PK,
930: PPTP PER_TIME_PERIODS_PK ,

Line 927: ASS PER_ASSIGNMENTS_F_N12,

923: select /*+ ORDERED INDEX(BAL_ASSACT PAY_ASSIGNMENT_ACTIONS_PK,
924: BACT PAY_PAYROLL_ACTIONS_PK,
925: BPTP PER_TIME_PERIODS_PK,
926: START_ASS PER_ASSIGNMENTS_F_PK,
927: ASS PER_ASSIGNMENTS_F_N12,
928: ASSACT PAY_ASSIGNMENT_ACTIONS_N51,
929: PACT PAY_PAYROLL_ACTIONS_PK,
930: PPTP PER_TIME_PERIODS_PK ,
931: RR PAY_RUN_RESULTS_N50,

Line 1004: ( select /*+ ORDERED INDEX (NASS PER_ASSIGNMENTS_F_PK,

1000: and PACT.effective_date >=
1001: /* find the latest td payroll transfer date - compare each of the */
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,

Line 1005: PASS PER_ASSIGNMENTS_F_PK,

1001: /* find the latest td payroll transfer date - compare each of the */
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)

Line 1141: per_assignments_f ASS

1137: select nvl(min(p.effective_start_date)
1138: ,to_date('31-12-4712','dd-mm-yyyy'))
1139: into l_start_of_director_date
1140: from per_people_f p,
1141: per_assignments_f ASS
1142: where p.per_information2 = 'Y'
1143: and ASS.assignment_id = p_assignment_id
1144: and l_effective_date between
1145: ASS.effective_start_date and ASS.effective_end_date

Line 1596: from per_assignments_f a, per_assignment_status_types st

1592: --
1593: l_count := 0;
1594:
1595: select count(1) into l_count
1596: from per_assignments_f a, per_assignment_status_types st
1597: where st.assignment_status_type_id = a.assignment_status_type_id
1598: and p_date between a.effective_start_date and a.effective_end_date
1599: and a.payroll_id = p_payroll_id
1600: and st.pay_system_status = 'P';

Line 1631: per_assignments_f a,

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
1635: and l_effective_date

Line 1649: per_assignments_f a,

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

Line 1708: index(a per_assignments_f_pk)

1704: select
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

Line 1733: index(a per_assignments_f_n12)

1729: select
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: */

Line 2035: START_ASS PER_ASSIGNMENTS_F_PK,

2031: /* OF SELECTION FROM BALANCE TABLES. */
2032: select /*+ ORDERED INDEX(BAL_ASSACT PAY_ASSIGNMENT_ACTIONS_PK,
2033: BACT PAY_PAYROLL_ACTIONS_PK,
2034: BPTP PER_TIME_PERIODS_PK,
2035: START_ASS PER_ASSIGNMENTS_F_PK,
2036: ASS PER_ASSIGNMENTS_N4,
2037: ASSACT PAY_ASSIGNMENT_ACTIONS_N51,
2038: PACT PAY_PAYROLL_ACTIONS_PK,
2039: PPTP PER_TIME_PERIODS_PK ,

Line 2113: ( select /*+ ORDERED INDEX (NASS PER_ASSIGNMENTS_F_PK,

2109: and PACT.effective_date >=
2110: /* find the latest td payroll transfer date - compare each of the */
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,

Line 2114: PASS PER_ASSIGNMENTS_F_PK,

2110: /* find the latest td payroll transfer date - compare each of the */
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)

Line 2236: from per_assignments_f paf,

2232: select ptp.regular_payment_date,
2233: ptp.period_type,
2234: ptp.start_date,
2235: ptp.end_date
2236: from per_assignments_f paf,
2237: per_time_periods ptp
2238: where paf.assignment_id = c_assignment_id
2239: and ptp.payroll_id = paf.payroll_id
2240: and c_effective_date between