APPS.PAY_ELEMENT_EXTRACT_PKG dependencies on FND_COMMON_LOOKUPS

Line 62: FND_COMMON_LOOKUPS table using

58:
59: 05-AUG-2003 trugless 115.13 Replaced hardcoded text for
60: report headings and
61: gv_title with lookup to
62: FND_COMMON_LOOKUPS table using
63: hr_general.decode_fnd_comm_lookup
64: function
65:
66: Modified c_element_results,

Line 706: fnd_common_lookups fcl

702: pay_assignment_actions paa,
703: per_assignments_f paf,
704: per_people_f ppf,
705: pay_payrolls_f pf,
706: fnd_common_lookups fcl
707: where ppa.action_type in ('R', 'Q', 'B', 'I', 'V')
708: and ppa.business_group_id = cp_business_group_id
709: --
710: and pf.payroll_id = ppa.payroll_id

Line 989: from fnd_common_lookups fcl

985: ** Cursor to return the Employement Category from Lookups
986: *************************************************************/
987: cursor c_employment_category (cp_lookup_code in varchar2) is
988: select fcl.meaning
989: from fnd_common_lookups fcl
990: where fcl.lookup_type = 'EMP_CAT'
991: and fcl.lookup_code = cp_lookup_code;
992:
993: /*************************************************************