APPS.PAY_PURGE_PKG dependencies on PER_BUSINESS_GROUPS

Line 125: ,legislation_code per_business_groups.legislation_code%type

121: --
122: type t_payact_rec is record
123: (payroll_action_id number
124: ,business_group_id number
125: ,legislation_code per_business_groups.legislation_code%type
126: ,effective_date date
127: ,asg_count number -- number of assignments to process.
128: );
129:

Line 273: ,per_business_groups_perf pbg

269: ,ppa.effective_date
270: ,ppa.balance_set_id
271: from
272: pay_payroll_actions ppa
273: ,per_business_groups_perf pbg
274: where
275: ppa.payroll_action_id = p_purge_action_id
276: and pbg.business_group_id = ppa.business_group_id
277: ;

Line 1160: l_bg_name per_business_groups.name%type;

1156: l_iv_id pay_input_values_f.input_value_id%type;
1157: l_el_id pay_element_links_f.element_link_id%type;
1158: l_et_name pay_element_types_f.element_name%type;
1159: l_iv_name pay_input_values_f.name%type;
1160: l_bg_name per_business_groups.name%type;
1161: l_et_count number := 0;
1162:
1163: type et_r is record
1164: (

Line 1315: l_bg_id per_business_groups.business_group_id%type;

1311: p_seq in number,
1312: p_bt_id in number default null
1313: ) return number is
1314: l_et_name pay_element_types_f.element_name%type;
1315: l_bg_id per_business_groups.business_group_id%type;
1316: l_et_id pay_element_types_f.element_type_id%type;
1317:
1318: begin
1319:

Line 1400: from per_business_groups pbg

1396: hr_utility.set_location('pay_purge_pkg.pypurcif', 10);
1397:
1398: select pbg.name
1399: into l_bg_name
1400: from per_business_groups pbg
1401: where pbg.business_group_id = p_business_group_id;
1402:
1403: -- Return all the balance types that might need to have
1404: -- balances rolled up for them by purge.