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 697: fnd_common_lookups fcl

693: pay_assignment_actions paa,
694: per_assignments_f paf,
695: per_people_f ppf,
696: pay_payrolls_f pf,
697: fnd_common_lookups fcl
698: where ppa.action_type in ('R', 'Q', 'B', 'I', 'V')
699: and ppa.business_group_id = cp_business_group_id
700: --
701: and pf.payroll_id = ppa.payroll_id

Line 980: from fnd_common_lookups fcl

976: ** Cursor to return the Employement Category from Lookups
977: *************************************************************/
978: cursor c_employment_category (cp_lookup_code in varchar2) is
979: select fcl.meaning
980: from fnd_common_lookups fcl
981: where fcl.lookup_type = 'EMP_CAT'
982: and fcl.lookup_code = cp_lookup_code;
983:
984: /*************************************************************