APPS.PAY_RUN_BALANCE_BUILD dependencies on PAY_BALANCE_ATTRIBUTES

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

651: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',20);
652: --
653: if (g_proc_mode = 'INVALID') then
654: --
655: -- altered delete statement to use pay_balance_attributes rather than
656: -- pay_balance_validation to identify rows to be deleted
657: --
658: /*Bug 9315998 Begin */
659: If g_att_cached = FALSE then

Line 663: from pay_balance_attributes pba

659: If g_att_cached = FALSE then
660: select pba.defined_balance_id
661: bulk collect
662: INTO g_tab_def_bal
663: from pay_balance_attributes pba
664: , pay_bal_attribute_definitions bad
665: where pba.attribute_id = bad.attribute_id
666: and bad.attribute_name = g_att_name;
667:

Line 1510: insert into pay_balance_attributes

1506: if g_debug then
1507: hr_utility.trace('generate_attribute. defined_balance_id:'||grprec.defined_balance_id||
1508: ' l_attribute_name:'||l_attribute_name);
1509: end if;
1510: insert into pay_balance_attributes
1511: (balance_attribute_id,
1512: attribute_id,
1513: defined_balance_id
1514: )

Line 1516: (pay_balance_attributes_s.nextval,

1512: attribute_id,
1513: defined_balance_id
1514: )
1515: values
1516: (pay_balance_attributes_s.nextval,
1517: l_attribute_id,
1518: grprec.defined_balance_id
1519: );
1520: end if;

Line 1554: insert into pay_balance_attributes

1550: if g_debug then
1551: hr_utility.trace('generate_attribute. defined_balance_id:'||asgrec.defined_balance_id||
1552: ' l_attribute_name:'||l_attribute_name);
1553: end if;
1554: insert into pay_balance_attributes
1555: (balance_attribute_id,
1556: attribute_id,
1557: defined_balance_id
1558: )

Line 1560: (pay_balance_attributes_s.nextval,

1556: attribute_id,
1557: defined_balance_id
1558: )
1559: values
1560: (pay_balance_attributes_s.nextval,
1561: l_attribute_id,
1562: asgrec.defined_balance_id
1563: );
1564: end if;

Line 1899: pay_balance_attributes ba

1895: bulk collect into g_old_balance_validation_tab
1896: from ( select bv.defined_balance_id,
1897: bv.balance_load_date, run_balance_status, bv.business_group_id,
1898: (select 'P' from pay_bal_attribute_definitions bad,
1899: pay_balance_attributes ba
1900: where bad.attribute_name = g_att_name
1901: and bad.ATTRIBUTE_ID = ba.ATTRIBUTE_ID
1902: and ba.defined_balance_id = bv.defined_balance_id) balance_status
1903: from pay_balance_validation bv

Line 2009: delete from pay_balance_attributes

2005: if (remove_act is null or remove_act = 'Y') then
2006: pay_archive.remove_report_actions(pactid);
2007: --
2008: --
2009: delete from pay_balance_attributes
2010: where attribute_id in (select attribute_id
2011: from pay_bal_attribute_definitions
2012: where attribute_name = g_att_name
2013: );