APPS.HR_GBNIDIR dependencies on PER_ALL_ASSIGNMENTS_F

Line 972: ,per_all_assignments_f START_ASS

968: from
969: pay_assignment_actions BAL_ASSACT
970: ,pay_payroll_actions BACT
971: ,per_time_periods BPTP
972: ,per_all_assignments_f START_ASS
973: ,per_all_assignments_f ASS
974: ,pay_assignment_actions ASSACT
975: ,pay_payroll_actions PACT
976: ,per_time_periods PPTP

Line 973: ,per_all_assignments_f ASS

969: pay_assignment_actions BAL_ASSACT
970: ,pay_payroll_actions BACT
971: ,per_time_periods BPTP
972: ,per_all_assignments_f START_ASS
973: ,per_all_assignments_f ASS
974: ,pay_assignment_actions ASSACT
975: ,pay_payroll_actions PACT
976: ,per_time_periods PPTP
977: ,pay_run_results RR

Line 1012: from per_all_assignments_f NASS

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
1014: ,pay_all_payrolls_f ROLL
1015: ,hr_soft_coding_keyflex FLEX
1016: ,pay_all_payrolls_f PROLL

Line 1013: ,per_all_assignments_f PASS

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
1014: ,pay_all_payrolls_f ROLL
1015: ,hr_soft_coding_keyflex FLEX
1016: ,pay_all_payrolls_f PROLL
1017: ,hr_soft_coding_keyflex PFLEX

Line 1713: from per_all_assignments_f a,

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,
1715: hr_soft_coding_keyflex FLEX
1716: where a.assignment_id = l_assignment_id
1717: and a.payroll_id = p.payroll_id

Line 1739: from per_all_assignments_f a,

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,
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

Line 2081: ,per_all_assignments_f START_ASS

2077: from
2078: pay_assignment_actions BAL_ASSACT
2079: ,pay_payroll_actions BACT
2080: ,per_time_periods BPTP
2081: ,per_all_assignments_f START_ASS
2082: ,per_all_assignments_f ASS
2083: ,pay_assignment_actions ASSACT
2084: ,pay_payroll_actions PACT
2085: ,per_time_periods PPTP

Line 2082: ,per_all_assignments_f ASS

2078: pay_assignment_actions BAL_ASSACT
2079: ,pay_payroll_actions BACT
2080: ,per_time_periods BPTP
2081: ,per_all_assignments_f START_ASS
2082: ,per_all_assignments_f ASS
2083: ,pay_assignment_actions ASSACT
2084: ,pay_payroll_actions PACT
2085: ,per_time_periods PPTP
2086: ,pay_run_results RR

Line 2121: from per_all_assignments_f NASS

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
2123: ,pay_all_payrolls_f ROLL
2124: ,hr_soft_coding_keyflex FLEX
2125: ,pay_all_payrolls_f PROLL

Line 2122: ,per_all_assignments_f PASS

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
2123: ,pay_all_payrolls_f ROLL
2124: ,hr_soft_coding_keyflex FLEX
2125: ,pay_all_payrolls_f PROLL
2126: ,hr_soft_coding_keyflex PFLEX