APPS.PAY_GB_ENH_RETRO_PAY dependencies on PAY_UPGRADE_DEFINITIONS

Line 38: pay_upgrade_definitions

34: (
35: SELECT
36: UPGRADE_DEFINITION_ID
37: FROM
38: pay_upgrade_definitions
39: WHERE
40: legislation_code='GB'
41: AND short_name ='GB_ENHANCED_RETROPAY'
42: );

Line 48: pay_upgrade_definitions

44: IS
45: SELECT
46: UPGRADE_DEFINITION_ID
47: FROM
48: pay_upgrade_definitions
49: WHERE
50: legislation_code='GB'
51: AND short_name ='GB_ENHANCED_RETROPAY';
52: l_element_type_id pay_element_types_f.element_type_id%TYPE;

Line 55: l_definition_id pay_upgrade_definitions.UPGRADE_DEFINITION_ID%TYPE;

51: AND short_name ='GB_ENHANCED_RETROPAY';
52: l_element_type_id pay_element_types_f.element_type_id%TYPE;
53: l_element_validity BOOLEAN;
54: l_completion_status pay_upgrade_status.STATUS%TYPE;
55: l_definition_id pay_upgrade_definitions.UPGRADE_DEFINITION_ID%TYPE;
56: BEGIN
57: OPEN c_get_completion_status;
58: FETCH
59: c_get_completion_status

Line 112: pay_upgrade_definitions

108: (
109: SELECT
110: UPGRADE_DEFINITION_ID
111: FROM
112: pay_upgrade_definitions
113: WHERE
114: legislation_code='GB'
115: AND short_name ='GB_ENHANCED_RETROPAY'
116: );