APPS.PAY_RUN_BALANCE_BUILD dependencies on PAY_BALANCE_ATTRIBUTES

Line 545: -- altered delete statement to use pay_balance_attributes rather than

541: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',20);
542: --
543: if (g_proc_mode = 'INVALID') then
544: --
545: -- altered delete statement to use pay_balance_attributes rather than
546: -- pay_balance_validation to identify rows to be deleted
547: --
548: delete /*+ USE_NL(prb) INDEX(prb PAY_RUN_BALANCES_N1) */
549: from pay_run_balances prb

Line 553: from pay_balance_attributes pba

549: from pay_run_balances prb
550: where prb.assignment_id = p_asg_id
551: and prb.defined_balance_id in
552: (select pba.defined_balance_id
553: from pay_balance_attributes pba
554: , pay_bal_attribute_definitions bad
555: where pba.attribute_id = bad.attribute_id
556: and bad.attribute_name = g_att_name);
557: --

Line 1237: insert into pay_balance_attributes

1233: g_leg_code,
1234: g_proc_mode,
1235: g_def_bal_id) loop
1236: --
1237: insert into pay_balance_attributes
1238: (balance_attribute_id,
1239: attribute_id,
1240: defined_balance_id
1241: )

Line 1243: (pay_balance_attributes_s.nextval,

1239: attribute_id,
1240: defined_balance_id
1241: )
1242: values
1243: (pay_balance_attributes_s.nextval,
1244: l_attribute_id,
1245: grprec.defined_balance_id
1246: );
1247: --

Line 1260: insert into pay_balance_attributes

1256: g_leg_code,
1257: g_proc_mode,
1258: g_def_bal_id) loop
1259: --
1260: insert into pay_balance_attributes
1261: (balance_attribute_id,
1262: attribute_id,
1263: defined_balance_id
1264: )

Line 1266: (pay_balance_attributes_s.nextval,

1262: attribute_id,
1263: defined_balance_id
1264: )
1265: values
1266: (pay_balance_attributes_s.nextval,
1267: l_attribute_id,
1268: asgrec.defined_balance_id
1269: );
1270: --

Line 1570: delete from pay_balance_attributes

1566: if (remove_act is null or remove_act = 'Y') then
1567: pay_archive.remove_report_actions(pactid);
1568: --
1569: --
1570: delete from pay_balance_attributes
1571: where attribute_id in (select attribute_id
1572: from pay_bal_attribute_definitions
1573: where attribute_name = g_att_name
1574: );