APPS.PAY_ECU_BUS dependencies on PAY_ELEMENT_CLASS_USAGES_F

Line 31: , pay_element_class_usages_f ecu

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , pay_element_class_usages_f ecu
32: where ecu.element_class_usage_id = p_element_class_usage_id
33: and pbg.business_group_id (+) = ecu.business_group_id;
34: --
35: -- Declare local variables

Line 101: , pay_element_class_usages_f ecu

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , pay_element_class_usages_f ecu
102: where ecu.element_class_usage_id = p_element_class_usage_id
103: and pbg.business_group_id (+) = ecu.business_group_id;
104: --
105: -- Declare local variables

Line 244: l_legislation_code PAY_ELEMENT_CLASS_USAGES_F.legislation_code%TYPE;

240: and prt.legislation_code is null;
241: --
242: --
243: l_exists varchar2(2);
244: l_legislation_code PAY_ELEMENT_CLASS_USAGES_F.legislation_code%TYPE;
245: l_proc varchar2(72) := g_package||'chk_run_type_id';
246: --
247: Begin
248: hr_api.mandatory_arg_error

Line 304: 'PAY_ELEMENT_CLASS_USAGES_F.RUN_TYPE_ID') then

300: exception
301: when app_exception.application_exception then
302: if hr_multi_message.exception_add
303: (p_associated_column1 =>
304: 'PAY_ELEMENT_CLASS_USAGES_F.RUN_TYPE_ID') then
305: raise;
306: end if;
307: when others then
308: if csr_chk_generic_run_type%isopen then

Line 401: l_legislation_code PAY_ELEMENT_CLASS_USAGES_F.legislation_code%TYPE;

397: --
398:
399:
400: l_exists varchar2(2);
401: l_legislation_code PAY_ELEMENT_CLASS_USAGES_F.legislation_code%TYPE;
402: l_proc varchar2(72) := g_package||'chk_classification_id';
403: --
404: Begin
405: hr_api.mandatory_arg_error

Line 460: 'PAY_ELEMENT_CLASS_USAGES_F.CLASSIFICATION_ID') then

456: exception
457: when app_exception.application_exception then
458: if hr_multi_message.exception_add
459: (p_associated_column1 =>
460: 'PAY_ELEMENT_CLASS_USAGES_F.CLASSIFICATION_ID') then
461: raise;
462: end if;
463: when others then
464: if csr_chk_generic_ele_class%isopen then

Line 533: (p_associated_column1 => 'PAY_ELEMENT_CLASS_USAGES_F.LEGISLATION_CODE'

529: --
530: exception
531: when app_exception.application_exception then
532: if hr_multi_message.exception_add
533: (p_associated_column1 => 'PAY_ELEMENT_CLASS_USAGES_F.LEGISLATION_CODE'
534: ) then
535: raise;
536: end if;
537: when others then