APPS.PER_DATA_UPDATE_REPORT dependencies on PER_BUSINESS_GROUPS

Line 103: per_business_groups bus

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:
107: cursor c_detect_status (p_upgrade_definition_id number) is

Line 143: l_status_bg_name per_business_groups.name%type;

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;
147: l_lookup_execution_point varchar2(10);