[Home] [Help]
77: ,pap.accrual_category accrual_category
78: ,pap.accrual_plan_element_type_id accrual_plan_element_type_id
79: ,pee.effective_start_date effective_start_date
80: ,asg.payroll_id payroll_id
81: from pay_accrual_plans pap
82: ,pay_element_entries_f pee
83: ,per_all_assignments_f asg
84: where pap.business_group_id + 0 = p_business_group_id
85: and asg.assignment_id = p_assignment_id
1469:
1470: -- Cursor to check whether user has opted for regularization
1471: Cursor csr_reg_option_flg IS
1472: Select nvl(INFORMATION30, 'N') reg_flg
1473: from pay_accrual_plans
1474: where ACCRUAL_PLAN_ID = p_accrual_plan_id
1475: and INFORMATION_CATEGORY in ('FR_FR_MAIN_HOLIDAY', 'FR_FR_RTT_HOLIDAY', 'FR_FR_ADDITIONAL_HOLIDAY');
1476: --
1477: Begin
2172: and legislation_code = 'FR';
2173: --
2174: CURSOR csr_plan_type is
2175: select accrual_formula_id, co_formula_id
2176: from PAY_ACCRUAL_PLANS
2177: where ACCRUAL_PLAN_ID = p_plan_id
2178: and ACCRUAL_CATEGORY in ('FR_MAIN_HOLIDAY', 'FR_RTT_HOLIDAY', 'FR_ADDITIONAL_HOLIDAY');
2179: --
2180: -- Modified for bug 3730069
2208: and PTP.time_period_id = BACT.time_period_id
2209: /* Year To Date */
2210: and PACT.effective_date > (
2211: select nvl(min(PTP1.end_date),l_fr_plan_info.accrual_year_start)
2212: from PAY_ACCRUAL_PLANS PAP1
2213: ,per_time_periods PTP1
2214: where PAP1.ACCRUAL_PLAN_ID = l_fr_plan_info.accrual_plan_id
2215: and pap1.information1 is not null
2216: AND PTP1.payroll_id = BACT.payroll_id
2885: -- added for termination processing
2886: ,pivT.element_type_id TERM_element_id
2887: --
2888: ,pap.business_group_id business_Group_id
2889: from pay_accrual_plans pap
2890: ,pay_input_values_f piv
2891: ,pay_input_values_f pivE
2892: ,pay_input_values_f pivO
2893: ,pay_input_values_f pivA
2938: ,pivE.element_type_id ENT_element_id
2939: ,pivO.element_type_id OBS_element_id
2940: ,pivA.element_type_id ADJ_element_id
2941: ,pap.business_group_id business_Group_id
2942: from pay_accrual_plans pap
2943: ,per_absence_attendances paa
2944: ,per_absence_attendance_types pat
2945: ,pay_element_entries_f pee
2946: ,pay_input_values_f piv
4559: ,pivE.element_type_id ENT_element_id
4560: ,pivO.element_type_id OBS_element_id
4561: ,pivA.element_type_id ADJ_element_id
4562: ,pap.business_group_id business_Group_id
4563: from pay_accrual_plans pap
4564: ,pay_input_values_f piv
4565: ,pay_input_values_f pivE
4566: ,pay_input_values_f pivO
4567: ,pay_input_values_f pivA
4605: ,pivE.element_type_id ENT_element_id
4606: ,pivO.element_type_id OBS_element_id
4607: ,pivA.element_type_id ADJ_element_id
4608: ,pap.business_group_id business_Group_id
4609: from pay_accrual_plans pap
4610: ,per_absence_attendances paa
4611: ,per_absence_attendance_types pat
4612: ,pay_element_entries_f pee
4613: ,pay_input_values_f piv
5186: ) return number is
5187:
5188: CURSOR csr_get_plan is
5189: select pap.accrual_plan_id
5190: from pay_accrual_plans pap
5191: ,pay_element_entries_f pee
5192: ,pay_element_links_f pel
5193: where pee.element_entry_id = P_ELEMENT_ENTRY_ID
5194: and pee.element_link_id = pel.element_link_id