DBA Data[Home] [Help]

APPS.PQP_WEBADI_INTEGRATION_UTILS dependencies on HR_API

Line 22: decode(sign(instr(pltl.user_tip, HR_API.GET_LEGISLATION_CONTEXT)), 1, 'Y', 'N'), '-', decode(sign(instr(pltl.user_tip,

18: bne_param_lists_tl pltl
19: WHERE plb.param_list_code = p_caller_identifier
20: AND plb.param_list_code = pltl.param_list_code
21: AND decode(pltl.user_tip, NULL, 'Y', decode(substr(pltl.user_tip,1,1), '+',
22: decode(sign(instr(pltl.user_tip, HR_API.GET_LEGISLATION_CONTEXT)), 1, 'Y', 'N'), '-', decode(sign(instr(pltl.user_tip,
23: HR_API.GET_LEGISLATION_CONTEXT)), 1, 'N', 'Y'), 'Y' ) ) = 'Y'
24: AND pltl.application_id = p_application_id
25: AND plb.application_id = p_application_id
26: AND pltl.language = userenv('lang');

Line 23: HR_API.GET_LEGISLATION_CONTEXT)), 1, 'N', 'Y'), 'Y' ) ) = 'Y'

19: WHERE plb.param_list_code = p_caller_identifier
20: AND plb.param_list_code = pltl.param_list_code
21: AND decode(pltl.user_tip, NULL, 'Y', decode(substr(pltl.user_tip,1,1), '+',
22: decode(sign(instr(pltl.user_tip, HR_API.GET_LEGISLATION_CONTEXT)), 1, 'Y', 'N'), '-', decode(sign(instr(pltl.user_tip,
23: HR_API.GET_LEGISLATION_CONTEXT)), 1, 'N', 'Y'), 'Y' ) ) = 'Y'
24: AND pltl.application_id = p_application_id
25: AND plb.application_id = p_application_id
26: AND pltl.language = userenv('lang');
27: