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 850: START_ASS PER_ASSIGNMENTS_F_PK,

846: OR g_assignment_action_id is null then
847: select /*+ ORDERED INDEX(BAL_ASSACT PAY_ASSIGNMENT_ACTIONS_PK,
848: BACT PAY_PAYROLL_ACTIONS_PK,
849: BPTP PER_TIME_PERIODS_PK,
850: START_ASS PER_ASSIGNMENTS_F_PK,
851: ASS PER_ASSIGNMENTS_F_N12,
852: ASSACT PAY_ASSIGNMENT_ACTIONS_N51,
853: PACT PAY_PAYROLL_ACTIONS_PK,
854: PPTP PER_TIME_PERIODS_PK ,

Line 851: ASS PER_ASSIGNMENTS_F_N12,

847: select /*+ ORDERED INDEX(BAL_ASSACT PAY_ASSIGNMENT_ACTIONS_PK,
848: BACT PAY_PAYROLL_ACTIONS_PK,
849: BPTP PER_TIME_PERIODS_PK,
850: START_ASS PER_ASSIGNMENTS_F_PK,
851: ASS PER_ASSIGNMENTS_F_N12,
852: ASSACT PAY_ASSIGNMENT_ACTIONS_N51,
853: PACT PAY_PAYROLL_ACTIONS_PK,
854: PPTP PER_TIME_PERIODS_PK ,
855: RR PAY_RUN_RESULTS_N50,

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

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

Line 929: PASS PER_ASSIGNMENTS_F_PK,

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

Line 1065: per_assignments_f ASS

1061: select nvl(min(p.effective_start_date)
1062: ,to_date('31-12-4712','dd-mm-yyyy'))
1063: into l_start_of_director_date
1064: from per_people_f p,
1065: per_assignments_f ASS
1066: where p.per_information2 = 'Y'
1067: and ASS.assignment_id = p_assignment_id
1068: and l_effective_date between
1069: ASS.effective_start_date and ASS.effective_end_date

Line 1482: from per_assignments_f a, per_assignment_status_types st

1478: --
1479: l_count := 0;
1480:
1481: select count(1) into l_count
1482: from per_assignments_f a, per_assignment_status_types st
1483: where st.assignment_status_type_id = a.assignment_status_type_id
1484: and p_date between a.effective_start_date and a.effective_end_date
1485: and a.payroll_id = p_payroll_id
1486: and st.pay_system_status = 'P';

Line 1517: per_assignments_f a,

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

Line 1535: per_assignments_f a,

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

Line 1594: index(a per_assignments_f_pk)

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

Line 1619: index(a per_assignments_f_n12)

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

Line 1919: START_ASS PER_ASSIGNMENTS_F_PK,

1915: /* OF SELECTION FROM BALANCE TABLES. */
1916: select /*+ ORDERED INDEX(BAL_ASSACT PAY_ASSIGNMENT_ACTIONS_PK,
1917: BACT PAY_PAYROLL_ACTIONS_PK,
1918: BPTP PER_TIME_PERIODS_PK,
1919: START_ASS PER_ASSIGNMENTS_F_PK,
1920: ASS PER_ASSIGNMENTS_N4,
1921: ASSACT PAY_ASSIGNMENT_ACTIONS_N51,
1922: PACT PAY_PAYROLL_ACTIONS_PK,
1923: PPTP PER_TIME_PERIODS_PK ,

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

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

Line 1998: PASS PER_ASSIGNMENTS_F_PK,

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

Line 2120: from per_assignments_f paf,

2116: select ptp.regular_payment_date,
2117: ptp.period_type,
2118: ptp.start_date,
2119: ptp.end_date
2120: from per_assignments_f paf,
2121: per_time_periods ptp
2122: where paf.assignment_id = c_assignment_id
2123: and ptp.payroll_id = paf.payroll_id
2124: and c_effective_date between