[Home] [Help]
826: -- find the start of the financial year and the start of the directorship
827: select BACT.effective_date, BAL_ASSACT.assignment_id
828: into l_bact_effective_date, l_assignment_id
829: from pay_payroll_actions BACT,
830: pay_assignment_actions BAL_ASSACT
831: where BAL_ASSACT.assignment_action_id = p_assignment_action_id
832: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id;
833:
834: l_stat_period_start := hr_gbbal.span_start(l_bact_effective_date, 1, '06-04-');
843: -- NI ABLE CURSOR, USE THIS RATHER THAN CORE BUE DUE TO DIFFERING ROUTE ETC.
844: --
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,
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,
854: PPTP PER_TIME_PERIODS_PK ,
855: RR PAY_RUN_RESULTS_N50,
856: TARGET PAY_RUN_RESULT_VALUES_PK,
889: g_st_ni_d_able , g_st_ni_e_able , g_st_ni_f_able ,
890: g_st_ni_g_able , g_st_ni_j_able, g_st_ni_jp_able,
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
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
902: ,pay_run_result_values TARGET
1304: ptp.period_type
1305: into l_assignment_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
1578: Begin
1579: -- find the effective date and assignment for this action
1580: select assignment_id,effective_date
1581: into l_assignment_id,l_effective_date
1582: from pay_assignment_actions BASSACT,
1583: pay_payroll_actions BACT
1584: where BASSACT.assignment_action_id = p_assignment_action_id
1585: and BACT.payroll_action_id = BASSACT.payroll_action_id;
1586: --
1912: hr_utility.trace('Assignment Action: '||to_char(g_assignment_action_id));
1913: --
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,
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,
1923: PPTP PER_TIME_PERIODS_PK ,
1924: RR PAY_RUN_RESULTS_N50,
1925: TARGET PAY_RUN_RESULT_VALUES_PK,
1958: g_st_ni_d_able , g_st_ni_e_able , g_st_ni_f_able ,
1959: g_st_ni_g_able , g_st_ni_j_able, g_st_ni_jp_able,
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
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
1971: ,pay_run_result_values TARGET