APPS.PER_DATA_UPDATE_REPORT dependencies on PAY_UPGRADE_STATUS

Line 102: from pay_upgrade_status pus,

98: decode(pus.status, 'C', 'Complete',
99: 'P', 'Processing') status,
100: pus.executed executed,
101: pus.request_id request_id
102: from pay_upgrade_status pus,
103: per_business_groups bus
104: where pus.upgrade_definition_id = lp_upgrade_definition_id
105: and pus.business_group_id = bus.business_group_id (+);
106:

Line 109: from pay_upgrade_status

105: and pus.business_group_id = bus.business_group_id (+);
106:
107: cursor c_detect_status (p_upgrade_definition_id number) is
108: select upgrade_definition_id
109: from pay_upgrade_status
110: where upgrade_definition_id = p_upgrade_definition_id;
111:
112: cursor c_profile_option_name (p_config_option_name varchar2) is
113: select user_profile_option_name

Line 142: l_status_leg_code pay_upgrade_status.legislation_code%type;

138: l_option_name varchar2(80);
139: l_execution_point varchar2(80);
140: l_exec_lookup_type varchar2(80);
141: l_exec_status varchar2(10);
142: l_status_leg_code pay_upgrade_status.legislation_code%type;
143: l_status_bg_name per_business_groups.name%type;
144: l_status pay_upgrade_status.status%type;
145: l_executed varchar2(10);
146: l_leg_code_rows number;

Line 144: l_status pay_upgrade_status.status%type;

140: l_exec_lookup_type varchar2(80);
141: l_exec_status varchar2(10);
142: l_status_leg_code pay_upgrade_status.legislation_code%type;
143: l_status_bg_name per_business_groups.name%type;
144: l_status pay_upgrade_status.status%type;
145: l_executed varchar2(10);
146: l_leg_code_rows number;
147: l_lookup_execution_point varchar2(10);
148: l_lookup_no varchar2(10);

Line 150: l_request_id pay_upgrade_status.request_id%type;

146: l_leg_code_rows number;
147: l_lookup_execution_point varchar2(10);
148: l_lookup_no varchar2(10);
149: l_lookup_yes varchar2(10);
150: l_request_id pay_upgrade_status.request_id%type;
151: l_rows_found boolean;
152: l_sql varchar2(400);
153: l_str_start varchar2(100);
154: l_str_dbname varchar2(100);