APPS.PAY_GB_ENH_RETRO_PAY dependencies on PAY_UPGRADE_STATUS

Line 31: pay_upgrade_status

27: IS
28: SELECT
29: STATUS
30: FROM
31: pay_upgrade_status
32: WHERE
33: UPGRADE_DEFINITION_ID IN
34: (
35: SELECT

Line 54: l_completion_status pay_upgrade_status.STATUS%TYPE;

50: legislation_code='GB'
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

Line 89: pay_upgrade_status

85: l_definition_id;
86: CLOSE c_get_upgrade_definition;
87: INSERT
88: INTO
89: pay_upgrade_status
90: (
91: UPGRADE_DEFINITION_ID,
92: STATUS,
93: LEGISLATION_CODE

Line 103: pay_upgrade_status

99: 'GB'
100: );
101: ELSE
102: UPDATE
103: pay_upgrade_status
104: SET
105: status = 'C'
106: WHERE
107: UPGRADE_DEFINITION_ID IN