APPS.PAY_FR_UPDATE_PCS_CODE dependencies on FND_COMMON_LOOKUPS

Line 17: from fnd_common_lookups fcl

13: from per_jobs pj
14: where business_group_id = c_business_group_id
15: and JOB_INFORMATION_CATEGORY = 'FR'
16: and not exists (select 1
17: from fnd_common_lookups fcl
18: where fcl.lookup_type = 'FR_NEW_PCS_CODE'
19: and fcl.lookup_code = pj.job_information1);
20:
21: cursor csr_get_new_code (c_pcs_code in varchar2) is

Line 23: from fnd_common_lookups

19: and fcl.lookup_code = pj.job_information1);
20:
21: cursor csr_get_new_code (c_pcs_code in varchar2) is
22: select description new_code
23: from fnd_common_lookups
24: where lookup_code = c_pcs_code
25: and lookup_type = 'FR_PCS_CODE';
26:
27: l_new_code fnd_common_lookups.description%type;

Line 27: l_new_code fnd_common_lookups.description%type;

23: from fnd_common_lookups
24: where lookup_code = c_pcs_code
25: and lookup_type = 'FR_PCS_CODE';
26:
27: l_new_code fnd_common_lookups.description%type;
28:
29: --Getting the message
30: l_value varchar2(240);
31: