eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_ENROLL_INFO_GENE dependencies on PAY_ELEMENT_TYPES_F

Line 123: FROM pay_input_values_f iv,pay_element_types_f et where

119:
120: FROM (
121: SELECT input_value_id
122: , name
123: FROM pay_input_values_f iv,pay_element_types_f et where
124: et.element_type_id = iv.element_type_id
125: and et.element_name = 'Pensions Information'
126: );
127:

Line 146: select 1 from pay_element_entries_f peef,pay_element_types_f petf where

142: AND l_prp_end_date BETWEEN
143: papf.effective_start_date and papf.effective_end_date;
144:
145: cursor c_pension_info_check(p_assignment_id number) is
146: select 1 from pay_element_entries_f peef,pay_element_types_f petf where
147: peef.element_type_id = petf.element_type_id
148: and petf.element_name = 'Pensions Information'
149: and p_assignment_id = peef.assignment_id
150: AND l_prp_end_date BETWEEN

Line 227: pay_element_types_f petf

223: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.elig_jh_date,screen_entry_value, null))) elig_jh_date,
224: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.opt_out_date,screen_entry_value, null))) opt_out_date
225: from pay_element_entry_values_f peevf,
226: pay_element_entries_f peef,
227: pay_element_types_f petf
228: where peevf.input_value_id in (l_input_value_ids.qualifying_scheme_name ,
229: --l_input_value_ids.g_agg_earnings_pensions_id ,
230: l_input_value_ids.auto_enrollment_date ,
231: l_input_value_ids.pension_classification ,

Line 249: and l_prp_end_date -- Not Needed for pay_element_types_f -Review again against the bug 14813352

245: and l_prp_end_date -- Review again against the bug 14813352
246: between peevf.effective_start_date and peevf.effective_end_date
247: and l_prp_end_date -- Review again against the bug 14813352
248: between peef.effective_start_date and peef.effective_end_date
249: and l_prp_end_date -- Not Needed for pay_element_types_f -Review again against the bug 14813352
250: between petf.effective_start_date and petf.effective_end_date
251: group by peevf.element_entry_id;
252:
253: l_global_value c_get_global_value%rowtype;

Line 358: AND PEEF.ELEMENT_TYPE_ID in (select ELEMENT_TYPE_ID from pay_element_types_f where

354: IS
355: SELECT ELEMENT_ENTRY_ID, GREATEST(EFFECTIVE_START_DATE,l_PRP_START_DATE) START_DATE
356: FROM PAY_ELEMENT_ENTRIES_F PEEF
357: WHERE ASSIGNMENT_ID =P_ASSIGNMENT_ID
358: AND PEEF.ELEMENT_TYPE_ID in (select ELEMENT_TYPE_ID from pay_element_types_f where
359: element_name ='Pensions Information' and legislation_code ='GB')
360: AND l_PRP_START_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
361: -- OR EFFECTIVE_START_DATE > l_PRP_START_DATE);
362: