APPS.PAY_RUN_BALANCE_BUILD dependencies on PAY_BAL_ATTRIBUTE_DEFINITIONS

Line 664: , pay_bal_attribute_definitions bad

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:
668: g_att_cached := TRUE;

Line 1454: l_attribute_name pay_bal_attribute_definitions.attribute_name%type;

1450: (pdb.legislation_code is null
1451: and pdb.business_group_id is null)
1452: );
1453: --
1454: l_attribute_name pay_bal_attribute_definitions.attribute_name%type;
1455: l_attribute_id pay_bal_attribute_definitions.attribute_id%type;
1456: l_purge_only boolean;
1457: begin
1458: --

Line 1455: l_attribute_id pay_bal_attribute_definitions.attribute_id%type;

1451: and pdb.business_group_id is null)
1452: );
1453: --
1454: l_attribute_name pay_bal_attribute_definitions.attribute_name%type;
1455: l_attribute_id pay_bal_attribute_definitions.attribute_id%type;
1456: l_purge_only boolean;
1457: begin
1458: --
1459: -- Use for both DELTA and NON DELTA modes

Line 1471: insert into pay_bal_attribute_definitions

1467: select pay_bal_attribute_definition_s.nextval
1468: into l_attribute_id
1469: from dual;
1470: --
1471: insert into pay_bal_attribute_definitions
1472: (attribute_id,
1473: attribute_name,
1474: alterable,
1475: business_group_id)

Line 1898: (select 'P' from pay_bal_attribute_definitions bad,

1894: case when balance_status is null then 'Y' else 'N' end purge_only
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

Line 2011: from pay_bal_attribute_definitions

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: );
2014: delete from pay_bal_attribute_definitions
2015: where attribute_name = g_att_name;

Line 2014: delete from pay_bal_attribute_definitions

2010: where attribute_id in (select attribute_id
2011: from pay_bal_attribute_definitions
2012: where attribute_name = g_att_name
2013: );
2014: delete from pay_bal_attribute_definitions
2015: where attribute_name = g_att_name;
2016: end if;
2017: end if;
2018: --