[Home] [Help]
921: IF g_assignment_action_id <> p_assignment_action_id
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,
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,
932: TARGET PAY_RUN_RESULT_VALUES_PK,
933: FEED PAY_BALANCE_FEEDS_F_UK2 )
934: USE_NL(BAL_ASSACT,BACT,BPTP,START_ASS,ASS,ASSACT,PACT,PPTP,RR,TARGET,FEED) +*/
967: g_st_ni_l_able, g_st_ni_s_able
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
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
978: ,pay_run_result_values TARGET
979: ,pay_balance_feeds_f FEED
980: where BAL_ASSACT.assignment_action_id = p_assignment_action_id
1406: l_effective_date,
1407: l_payroll_period_type
1408: from pay_assignment_actions act,
1409: pay_payroll_actions pact,
1410: per_time_periods ptp
1411: where act.assignment_action_id = p_assignment_action_id
1412: and pact.payroll_action_id = act.payroll_action_id
1413: and ptp.time_period_id = pact.time_period_id;
1414: --
2030: /* NI ABLE CURSOR WHICH REMAINS DUE TO USING VARIANT ROUTE AND STYLE */
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,
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 ,
2040: RR PAY_RUN_RESULTS_N50,
2041: TARGET PAY_RUN_RESULT_VALUES_PK,
2042: FEED PAY_BALANCE_FEEDS_F_UK2)
2043: USE_NL(BAL_ASSACT,BACT,BPTP,START_ASS,ASS,ASSACT,PACT,PPTP,RR,TARGET,FEED) +*/
2076: g_st_ni_l_able, g_st_ni_s_able
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
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
2087: ,pay_run_result_values TARGET
2088: ,pay_balance_feeds_f FEED
2089: where BAL_ASSACT.assignment_action_id = p_assignment_action_id
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
2241: ptp.start_date and ptp.end_date