[Home] [Help]
845: IF g_assignment_action_id <> p_assignment_action_id
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,
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,
856: TARGET PAY_RUN_RESULT_VALUES_PK,
857: FEED PAY_BALANCE_FEEDS_F_UK2 )
858: USE_NL(BAL_ASSACT,BACT,BPTP,START_ASS,ASS,ASSACT,PACT,PPTP,RR,TARGET,FEED) +*/
891: g_st_ni_l_able, g_st_ni_s_able
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
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
902: ,pay_run_result_values TARGET
903: ,pay_balance_feeds_f FEED
904: where BAL_ASSACT.assignment_action_id = p_assignment_action_id
1306: l_effective_date,
1307: l_payroll_period_type
1308: from pay_assignment_actions act,
1309: pay_payroll_actions pact,
1310: per_time_periods ptp
1311: where act.assignment_action_id = p_assignment_action_id
1312: and pact.payroll_action_id = act.payroll_action_id
1313: and ptp.time_period_id = pact.time_period_id;
1314: --
1914: /* NI ABLE CURSOR WHICH REMAINS DUE TO USING VARIANT ROUTE AND STYLE */
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,
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 ,
1924: RR PAY_RUN_RESULTS_N50,
1925: TARGET PAY_RUN_RESULT_VALUES_PK,
1926: FEED PAY_BALANCE_FEEDS_F_UK2)
1927: USE_NL(BAL_ASSACT,BACT,BPTP,START_ASS,ASS,ASSACT,PACT,PPTP,RR,TARGET,FEED) +*/
1960: g_st_ni_l_able, g_st_ni_s_able
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
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
1971: ,pay_run_result_values TARGET
1972: ,pay_balance_feeds_f FEED
1973: where BAL_ASSACT.assignment_action_id = p_assignment_action_id
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
2125: ptp.start_date and ptp.end_date