[Home] [Help]
901: --
902: -- find the start of the financial year and the start of the directorship
903: select BACT.effective_date, BAL_ASSACT.assignment_id
904: into l_bact_effective_date, l_assignment_id
905: from pay_payroll_actions BACT,
906: pay_assignment_actions BAL_ASSACT
907: where BAL_ASSACT.assignment_action_id = p_assignment_action_id
908: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id;
909:
920: --
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,
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,
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 )
966: g_st_ni_g_able , g_st_ni_j_able, g_st_ni_jp_able,
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
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
978: ,pay_run_result_values TARGET
979: ,pay_balance_feeds_f FEED
1405: into l_assignment_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;
1693: -- find the effective date and assignment for this action
1694: select assignment_id,effective_date
1695: into l_assignment_id,l_effective_date
1696: from pay_assignment_actions BASSACT,
1697: pay_payroll_actions BACT
1698: where BASSACT.assignment_action_id = p_assignment_action_id
1699: and BACT.payroll_action_id = BASSACT.payroll_action_id;
1700: --
1701: begin
2029: --
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,
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,
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)
2075: g_st_ni_g_able , g_st_ni_j_able, g_st_ni_jp_able,
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
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
2087: ,pay_run_result_values TARGET
2088: ,pay_balance_feeds_f FEED