DBA Data[Home] [Help]

APPS.HR_GBNIDIR dependencies on PER_ALL_ASSIGNMENTS_F

Line 896: ,per_all_assignments_f START_ASS

892: from
893: pay_assignment_actions BAL_ASSACT
894: ,pay_payroll_actions BACT
895: ,per_time_periods BPTP
896: ,per_all_assignments_f START_ASS
897: ,per_all_assignments_f ASS
898: ,pay_assignment_actions ASSACT
899: ,pay_payroll_actions PACT
900: ,per_time_periods PPTP

Line 897: ,per_all_assignments_f ASS

893: pay_assignment_actions BAL_ASSACT
894: ,pay_payroll_actions BACT
895: ,per_time_periods BPTP
896: ,per_all_assignments_f START_ASS
897: ,per_all_assignments_f ASS
898: ,pay_assignment_actions ASSACT
899: ,pay_payroll_actions PACT
900: ,per_time_periods PPTP
901: ,pay_run_results RR

Line 936: from per_all_assignments_f NASS

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
937: ,per_all_assignments_f PASS
938: ,pay_all_payrolls_f ROLL
939: ,hr_soft_coding_keyflex FLEX
940: ,pay_all_payrolls_f PROLL

Line 937: ,per_all_assignments_f PASS

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
937: ,per_all_assignments_f PASS
938: ,pay_all_payrolls_f ROLL
939: ,hr_soft_coding_keyflex FLEX
940: ,pay_all_payrolls_f PROLL
941: ,hr_soft_coding_keyflex PFLEX

Line 1599: from per_all_assignments_f a,

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,
1600: pay_all_payrolls_f p,
1601: hr_soft_coding_keyflex FLEX
1602: where a.assignment_id = l_assignment_id
1603: and a.payroll_id = p.payroll_id

Line 1625: from per_all_assignments_f a,

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
1625: from per_all_assignments_f a,
1626: pay_all_payrolls_f p,
1627: hr_soft_coding_keyflex FLEX,
1628: per_time_period_types ptpt
1629: where a.person_id = l_person_id

Line 1965: ,per_all_assignments_f START_ASS

1961: from
1962: pay_assignment_actions BAL_ASSACT
1963: ,pay_payroll_actions BACT
1964: ,per_time_periods BPTP
1965: ,per_all_assignments_f START_ASS
1966: ,per_all_assignments_f ASS
1967: ,pay_assignment_actions ASSACT
1968: ,pay_payroll_actions PACT
1969: ,per_time_periods PPTP

Line 1966: ,per_all_assignments_f ASS

1962: pay_assignment_actions BAL_ASSACT
1963: ,pay_payroll_actions BACT
1964: ,per_time_periods BPTP
1965: ,per_all_assignments_f START_ASS
1966: ,per_all_assignments_f ASS
1967: ,pay_assignment_actions ASSACT
1968: ,pay_payroll_actions PACT
1969: ,per_time_periods PPTP
1970: ,pay_run_results RR

Line 2005: from per_all_assignments_f NASS

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
2006: ,per_all_assignments_f PASS
2007: ,pay_all_payrolls_f ROLL
2008: ,hr_soft_coding_keyflex FLEX
2009: ,pay_all_payrolls_f PROLL

Line 2006: ,per_all_assignments_f PASS

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
2006: ,per_all_assignments_f PASS
2007: ,pay_all_payrolls_f ROLL
2008: ,hr_soft_coding_keyflex FLEX
2009: ,pay_all_payrolls_f PROLL
2010: ,hr_soft_coding_keyflex PFLEX