[Home] [Help]
576: CURSOR payroll_run_date_cur IS
577: SELECT /*+ use_nl(PTP) */ Max(ptp.end_date)
578: FROM pay_payroll_actions ppa,
579: pay_assignment_actions paa,
580: per_time_periods ptp
581: WHERE ppa.payroll_action_id = paa.payroll_action_id
582: and ppa.business_group_id = g_bg_id
583: AND ppa.payroll_id = l_payroll_id
584: AND ppa.action_type IN ( 'R','Q')
588:
589: /* Added for bug 2259310 */
590: CURSOR max_period_cur IS
591: SELECT NVL(MAX(time_period_id),0)
592: FROM per_time_periods
593: WHERE end_date = l_payroll_run_date
594: /***** Commented for bug fix 4625734
595: (SELECT MAX(date_earned)
596: FROM pay_payroll_actions ppa
831: End of comment for bug fix 4625734 *****/
832:
833:
834: /* Commented for bug 2259310 *******
835: (select max(time_period_id) from per_time_periods
836: --for bug fix 1971612 where end_date = (select max(effective_date)
837: where end_date = (select max(date_earned)
838: from pay_payroll_actions
839: where business_group_id = g_bg_id
871: AND time_period_id > p_max_time_period;
872: End of comment for bugfix 4625734 *****/
873:
874: /* Commented for bug 2259310 *****************************************
875: (select max(time_period_id) from per_time_periods
876: --for bug fix 1971612 where end_date = (select max(effective_date)
877: where end_date = (select max(date_earned)
878: from pay_payroll_actions
879: where business_group_id = g_bg_id
2863: --- moved this code out of int_cur loop for 2444657
2864: BEGIN
2865: SELECT period_name, end_date
2866: INTO l_period_name, l_period_end_dt
2867: FROM per_time_periods
2868: WHERE time_period_id = enc_control_rec.time_period_id ;
2869: EXCEPTION
2870: WHEN NO_DATA_FOUND THEN
2871: l_value := 'time period id =';
2868: WHERE time_period_id = enc_control_rec.time_period_id ;
2869: EXCEPTION
2870: WHEN NO_DATA_FOUND THEN
2871: l_value := 'time period id =';
2872: l_table := 'PER_TIME_PERIODS';
2873: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
2874: fnd_message.set_token('VALUE','l_value');
2875: fnd_message.set_token('TABLE','l_table');
2876: fnd_msg_pub.add;
4945: pec.payroll_id,
4946: pec.time_period_id,
4947: pec.gms_phase, ---- added for 2444657
4948: ptp.end_date
4949: per_time_periods ptp
4950: WHERE pec.payroll_id = nvl(p_payroll_id, pec.payroll_id)
4951: AND (pec.total_dr_amount IS NOT NULL OR pec.total_cr_amount IS NOT NULL)
4952: AND pec.action_type in ('N', 'Q', 'U') -- Included 'Q' for Enh. 2143723
4953: AND pec.action_code IN ('IT', 'IL','IU') -- Replaced I with IL and IU for Bug#2142865
4995: FROM psp_enc_summary_lines pesl,
4996: hr_organization_units hou, -- Introduced the following tables as part of bug fix 4625734
4997: pa_projects_all ppa,
4998: pa_tasks pt,
4999: per_time_periods ptp,
5000: per_all_people_f papf,
5001: psp_enc_controls pec
5002: WHERE pesl.payroll_action_id = p_payroll_action_id
5003: AND pec.enc_control_id = pesl.enc_control_id
5464: * /
5465: -- moved this code from below update enc summary lines.. for 2444657
5466: SELECT period_name, end_date
5467: INTO l_period_name, l_period_end_dt
5468: FROM per_time_periods
5469: WHERE time_period_id = enc_control_rec.time_period_id;
5470:
5471: if enc_control_rec.gms_phase = 'Summarize' then --- 2444657
5472: UPDATE psp_enc_summary_lines
7037: where CTRL.action_code = 'IT'
7038: and (CTRL.payroll_id, CTRL.time_period_id) in
7039: (select ASG.payroll_id, min(PER.time_period_id)
7040: from per_all_assignments_f ASG,
7041: per_time_periods PER
7042: where ASG.payroll_id = PER.payroll_id
7043: and ASG.person_id = p_person_id
7044: and p_Actual_term_date between PER.start_date and PER.end_date
7045: group by ASG.payroll_id)