[Home] [Help]
126: -- PACKAGE GLOBALS
127: g_ijss_refsal_defbal_id number;
128: g_map_refsal_defbal_id number;
129:
130: g_gi_info_element_type_id pay_element_types_f.element_type_id%type;
131: g_gi_info_absence_id_iv_id pay_input_values_f.input_value_id%type;
132: g_gi_info_guarantee_type_iv_id pay_input_values_f.input_value_id%type;
133: g_gi_info_guarantee_id_iv_id pay_input_values_f.input_value_id%type;
134: g_gi_info_gi_payment_iv_id pay_input_values_f.input_value_id%type;
142: g_gi_info_band2_iv_id pay_input_values_f.input_value_id%type;
143: g_gi_info_band3_iv_id pay_input_values_f.input_value_id%type;
144: g_gi_info_band4_iv_id pay_input_values_f.input_value_id%type;
145:
146: g_gi_i_r_element_type_id pay_element_types_f.element_type_id%type;
147: g_gi_i_r_absence_id_iv_id pay_input_values_f.input_value_id%type;
148: g_gi_i_r_guarantee_type_iv_id pay_input_values_f.input_value_id%type;
149: g_gi_i_r_guarantee_id_iv_id pay_input_values_f.input_value_id%type;
150: g_gi_i_r_gi_payment_iv_id pay_input_values_f.input_value_id%type;
158: g_gi_i_r_band2_iv_id pay_input_values_f.input_value_id%type;
159: g_gi_i_r_band3_iv_id pay_input_values_f.input_value_id%type;
160: g_gi_i_r_band4_iv_id pay_input_values_f.input_value_id%type;
161:
162: g_ben_element_type_id pay_element_types_f.element_type_id%type;
163: g_ben_absence_id_iv_id pay_input_values_f.input_value_id%type;
164: g_ben_guarantee_id_iv_id pay_input_values_f.input_value_id%type;
165: g_ben_guarantee_type_iv_id pay_input_values_f.input_value_id%type;
166: g_ben_waiting_days_iv_id pay_input_values_f.input_value_id%type;
2076: nvl(paa.abs_information8,'N') IJSS_estimate
2077: from
2078: pay_element_entries_f peef
2079: ,pay_element_links_f pelf
2080: ,pay_element_types_f petf
2081: ,per_absence_attendances paa
2082: where peef.assignment_id = p_asg.assignment_id
2083: and peef.element_link_id = pelf.element_link_id
2084: and pelf.element_type_id = petf.element_type_id
2125: pay_input_values_f piv_pst,
2126: pay_input_values_f piv_pet,
2127: pay_run_results prr_pst,
2128: pay_run_results prr_pet,
2129: pay_element_types_f peltf,
2130: pay_assignment_actions pact,
2131: pay_payroll_actions ppac
2132: --
2133: Where prrv_pst.result_value between fnd_date.date_to_canonical(c_abs_start_date) and fnd_date.date_to_canonical(c_abs_end_date)
2177: from pay_element_entry_values_f peval_pst,
2178: pay_element_entry_values_f peval_pet,
2179: pay_element_entries_f pentf,
2180: pay_element_links_f plink,
2181: pay_element_types_f peltf
2182: --
2183: where pentf.assignment_id = p_asg.assignment_id
2184: and pentf.element_link_id = plink.element_link_id
2185: and pentf.effective_start_date between p_asg.action_start_date and p_asg.action_end_date
2572: ,g_gi_info_band3_iv_id
2573: ,g_gi_info_band4_iv_id
2574: ,g_gi_info_start_date_iv_id
2575: ,g_gi_info_end_date_iv_id
2576: from pay_element_types_f e,
2577: pay_input_values_f i
2578: where e.element_name = 'FR_SICKNESS_GI_INFO'
2579: and e.legislation_code = 'FR'
2580: and e.element_type_id = i.element_type_id
2610: ,g_gi_i_r_band3_iv_id
2611: ,g_gi_i_r_band4_iv_id
2612: ,g_gi_i_r_start_date_iv_id
2613: ,g_gi_i_r_end_date_iv_id
2614: from pay_element_types_f e,
2615: pay_input_values_f i
2616: where e.element_name = 'FR_SICKNESS_GI_INFO_RETRO'
2617: and e.legislation_code = 'FR'
2618: and e.element_type_id = i.element_type_id
3719: ,g_ben_band3_rate_iv_id
3720: ,g_ben_band4_iv_id
3721: ,g_ben_band4_rate_iv_id
3722: ,g_ben_balance_iv_id
3723: from pay_element_types_f e,
3724: pay_input_values_f i
3725: where e.element_name = 'FR_SICK_BENEFIT'
3726: and e.legislation_code = 'FR'
3727: and e.element_type_id = i.element_type_id