DBA Data[Home] [Help]

APPS.PAY_IP_RETRO_UPGRADE dependencies on PAY_RETRO_COMPONENT_USAGES

Line 55: select pay_retro_component_usages_s.nextval

51: BEGIN
52: lv_procedure_name := '.insert_retro_comp_usages';
53: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
54:
55: select pay_retro_component_usages_s.nextval
56: into ln_retro_component_usage_id
57: from dual;
58:
59: insert into pay_retro_component_usages

Line 59: insert into pay_retro_component_usages

55: select pay_retro_component_usages_s.nextval
56: into ln_retro_component_usage_id
57: from dual;
58:
59: insert into pay_retro_component_usages
60: (retro_component_usage_id, retro_component_id, creator_id, creator_type,
61: default_component, reprocess_type, business_group_id, legislation_code,
62: creation_date, created_by, last_update_date, last_updated_by,
63: last_update_login, object_version_number)

Line 68: WHERE NOT EXISTS ( SELECT 1 FROM pay_retro_component_usages

64: select ln_retro_component_usage_id, p_retro_component_id, p_creator_id,
65: 'ET', 'Y', 'R', p_business_group_id, p_legislation_code,
66: sysdate, 2, sysdate, 2, 2, 1
67: from dual
68: WHERE NOT EXISTS ( SELECT 1 FROM pay_retro_component_usages
69: WHERE retro_component_id = p_retro_component_id
70: AND creator_id = p_creator_id
71: AND creator_type = 'ET');
72: