DBA Data[Home] [Help]

APPS.HR_RO_CONTRACT_VAL dependencies on HR_LOOKUPS

Line 14: from hr_lookups

10: IS
11:
12: cursor csr_contract_legal_susp_reason is
13: select 'x'
14: from hr_lookups
15: where lookup_type = 'RO_LEGAL_SUSPENDED_REASON'
16: and enabled_flag = 'Y'
17: and lookup_code = p_ctr_information1;
18:

Line 21: from hr_lookups

17: and lookup_code = p_ctr_information1;
18:
19: cursor csr_contract_legal_term_reason is
20: select 'x'
21: from hr_lookups
22: where lookup_type = 'RO_LEGAL_TERMINATED_REASON'
23: and enabled_flag = 'Y'
24: and lookup_code = p_ctr_information1;
25:

Line 28: from hr_lookups

24: and lookup_code = p_ctr_information1;
25:
26: cursor csr_contract_react_reason is
27: select 'x'
28: from hr_lookups
29: where lookup_type = 'RO_LEGAL_REACTIVATED_REASON'
30: and enabled_flag = 'Y'
31: and lookup_code = p_ctr_information1;
32: