APPS.PAY_CORE_UPGRADE_PKG dependencies on PER_BUSINESS_GROUPS

Line 1121: l_leg_code per_business_groups_perf.legislation_code%type;

1117: --
1118: asgt_action_ids t_asg_act_id;
1119: run_dates date_tab;
1120: --
1121: l_leg_code per_business_groups_perf.legislation_code%type;
1122: l_bus_grp per_business_groups_perf.business_group_id%type;
1123: l_found boolean := FALSE;
1124: l_status varchar2(30);
1125: --

Line 1122: l_bus_grp per_business_groups_perf.business_group_id%type;

1118: asgt_action_ids t_asg_act_id;
1119: run_dates date_tab;
1120: --
1121: l_leg_code per_business_groups_perf.legislation_code%type;
1122: l_bus_grp per_business_groups_perf.business_group_id%type;
1123: l_found boolean := FALSE;
1124: l_status varchar2(30);
1125: --
1126: cursor c_get_aas (p_assignment_id in number) is

Line 1142: per_business_groups_perf pbg

1138: --
1139: select pbg.legislation_code, pbg.business_group_id
1140: into l_leg_code, l_bus_grp
1141: from per_all_assignments_f asg,
1142: per_business_groups_perf pbg
1143: where asg.assignment_id = p_assignment_id
1144: and pbg.business_group_id = asg.business_group_id
1145: and rownum = 1;
1146: --

Line 1417: l_bus_grpid per_business_groups.business_group_id%type;

1413: 'V', 2,
1414: 1);
1415: --
1416: l_std_time_def_id pay_time_definitions.time_definition_id%type;
1417: l_bus_grpid per_business_groups.business_group_id%type;
1418: l_leg_code per_business_groups.legislation_code%type;
1419: l_complete pay_upgrade_status.status%type;
1420: --
1421: begin

Line 1418: l_leg_code per_business_groups.legislation_code%type;

1414: 1);
1415: --
1416: l_std_time_def_id pay_time_definitions.time_definition_id%type;
1417: l_bus_grpid per_business_groups.business_group_id%type;
1418: l_leg_code per_business_groups.legislation_code%type;
1419: l_complete pay_upgrade_status.status%type;
1420: --
1421: begin
1422: --

Line 1427: from per_business_groups_perf pbg,

1423: select distinct pbg.business_group_id,
1424: pbg.legislation_code
1425: into l_bus_grpid,
1426: l_leg_code
1427: from per_business_groups_perf pbg,
1428: per_all_assignments_f paf
1429: where paf.assignment_id = p_asg_id
1430: and paf.business_group_id = pbg.business_group_id;
1431: --