[Home] [Help]
578: CURSOR payroll_run_date_cur IS
579: SELECT /*+ use_nl(PTP) */ Max(ptp.end_date)
580: FROM pay_payroll_actions ppa,
581: pay_assignment_actions paa,
582: per_time_periods ptp
583: WHERE ppa.payroll_action_id = paa.payroll_action_id
584: and ppa.business_group_id = g_bg_id
585: AND ppa.payroll_id = l_payroll_id
586: AND ppa.action_type IN ( 'R','Q')
590:
591: /* Added for bug 2259310 */
592: CURSOR max_period_cur IS
593: SELECT NVL(MAX(time_period_id),0)
594: FROM per_time_periods
595: WHERE end_date = l_payroll_run_date
596: /***** Commented for bug fix 4625734
597: (SELECT MAX(date_earned)
598: FROM pay_payroll_actions ppa
833: End of comment for bug fix 4625734 *****/
834:
835:
836: /* Commented for bug 2259310 *******
837: (select max(time_period_id) from per_time_periods
838: --for bug fix 1971612 where end_date = (select max(effective_date)
839: where end_date = (select max(date_earned)
840: from pay_payroll_actions
841: where business_group_id = g_bg_id
873: AND time_period_id > p_max_time_period;
874: End of comment for bugfix 4625734 *****/
875:
876: /* Commented for bug 2259310 *****************************************
877: (select max(time_period_id) from per_time_periods
878: --for bug fix 1971612 where end_date = (select max(effective_date)
879: where end_date = (select max(date_earned)
880: from pay_payroll_actions
881: where business_group_id = g_bg_id
2916: --- moved this code out of int_cur loop for 2444657
2917: BEGIN
2918: SELECT period_name, end_date
2919: INTO l_period_name, l_period_end_dt
2920: FROM per_time_periods
2921: WHERE time_period_id = enc_control_rec.time_period_id ;
2922: EXCEPTION
2923: WHEN NO_DATA_FOUND THEN
2924: l_value := 'time period id =';
2921: WHERE time_period_id = enc_control_rec.time_period_id ;
2922: EXCEPTION
2923: WHEN NO_DATA_FOUND THEN
2924: l_value := 'time period id =';
2925: l_table := 'PER_TIME_PERIODS';
2926: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
2927: fnd_message.set_token('VALUE','l_value');
2928: fnd_message.set_token('TABLE','l_table');
2929: fnd_msg_pub.add;
5010: pec.payroll_id,
5011: pec.time_period_id,
5012: pec.gms_phase, ---- added for 2444657
5013: ptp.end_date
5014: per_time_periods ptp
5015: WHERE pec.payroll_id = nvl(p_payroll_id, pec.payroll_id)
5016: AND (pec.total_dr_amount IS NOT NULL OR pec.total_cr_amount IS NOT NULL)
5017: AND pec.action_type in ('N', 'Q', 'U') -- Included 'Q' for Enh. 2143723
5018: AND pec.action_code IN ('IT', 'IL','IU') -- Replaced I with IL and IU for Bug#2142865
5060: FROM psp_enc_summary_lines pesl,
5061: hr_organization_units hou, -- Introduced the following tables as part of bug fix 4625734
5062: pa_projects_all ppa,
5063: pa_tasks_expend_v pt, -- Replaced pa_tasks with pa_tasks_expend_v for Bug : 16391366
5064: per_time_periods ptp,
5065: per_all_people_f papf,
5066: psp_enc_controls pec
5067: WHERE pesl.payroll_action_id = p_payroll_action_id
5068: AND pec.enc_control_id = pesl.enc_control_id
5559: * /
5560: -- moved this code from below update enc summary lines.. for 2444657
5561: SELECT period_name, end_date
5562: INTO l_period_name, l_period_end_dt
5563: FROM per_time_periods
5564: WHERE time_period_id = enc_control_rec.time_period_id;
5565:
5566: if enc_control_rec.gms_phase = 'Summarize' then --- 2444657
5567: UPDATE psp_enc_summary_lines
7275: where CTRL.action_code = 'IT'
7276: and (CTRL.payroll_id, CTRL.time_period_id) in
7277: (select ASG.payroll_id, min(PER.time_period_id)
7278: from per_all_assignments_f ASG,
7279: per_time_periods PER
7280: where ASG.payroll_id = PER.payroll_id
7281: and ASG.person_id = p_person_id
7282: and p_Actual_term_date between PER.start_date and PER.end_date
7283: group by ASG.payroll_id)