APPS.PQP_GB_PENSION_SCHEME_UPDATE dependencies on PQP_GB_PENSION_SCHEME_UPDATE

Line 1: PACKAGE BODY PQP_GB_PENSION_SCHEME_UPDATE AS

1: PACKAGE BODY PQP_GB_PENSION_SCHEME_UPDATE AS
2: -- /* $Header: pqpgbschupd.pkb 120.0.12000000.1 2007/02/06 15:28:22 appldev noship $ */
3:
4: ----------------------------------------------------------------------------+
5: --This procedure is called from concurrent program to update

Line 76: where hr.lookup_type='PQP_GB_PENSION_SCHEME_UPDATE'

72: upper(hr.description) description
73: from hr_lookups hr,
74: pay_element_types_f petf,
75: pay_element_classifications pec
76: where hr.lookup_type='PQP_GB_PENSION_SCHEME_UPDATE'
77: and hr.enabled_flag='Y'
78: and (upper(hr.description) in ('COMP','COSR')
79: or hr.description is null)
80: and petf.element_name = hr.meaning

Line 177: END PQP_GB_PENSION_SCHEME_UPDATE;

173: errbuf := NULL;
174: retcode := PROGRAM_FAILURE ;
175: RAISE_APPLICATION_ERROR(-20001, SQLERRM);
176: End process_scheme_type;
177: END PQP_GB_PENSION_SCHEME_UPDATE;
178: