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.

[Home] [Help]

APPS.PAY_NL_ABP_ARCHIVE dependencies on PQP_PENSION_TYPES_F

Line 205: pqp_pension_types_f pty

201: pay_element_entries_f peef,
202: pay_element_links_f pelf,
203: pay_element_entry_values_f peev,
204: pay_input_values_f pivf,
205: pqp_pension_types_f pty
206: WHERE pei.information_type = 'PQP_NL_ABP_DEDUCTION'
207: AND pei.eei_information_category = 'PQP_NL_ABP_DEDUCTION'
208: AND c_effective_date BETWEEN to_date(pei.eei_information10,'DD/MM/RRRR') AND
209: to_date(pei.eei_information11,'DD/MM/RRRR')

Line 263: FROM pqp_pension_types_f pty

259: ,decode (pension_sub_category,'OPNP_65','A','OPNP_W25','B','OPNP_W50','C') pension_type_variant
260: ,-999999 contr_amt
261: ,ee_contribution_bal_type_id
262: ,er_contribution_bal_type_id
263: FROM pqp_pension_types_f pty
264: WHERE pension_sub_category IN ('OPNP_65','OPNP_W25','OPNP_W50','PPP','FPU_B')
265: AND business_group_id = c_bg_id
266: AND c_effective_date BETWEEN pty.effective_start_date AND
267: pty.effective_end_date