DBA Data[Home] [Help]

APPS.PAY_ELEMENT_TEMPLATE_GEN dependencies on PAY_DEFINED_BALANCES

Line 753: from pay_defined_balances

749: where balance_type_id = p_core_object_id;
750: --
751: cursor csr_sdb_core_object_exists(p_core_object_id in number) is
752: select count(0)
753: from pay_defined_balances
754: where defined_balance_id = p_core_object_id;
755: --
756: cursor csr_ssr_core_object_exists(p_core_object_id in number) is
757: select count(0)

Line 1389: pay_defined_balances_pkg.insert_row

1385: p_sbt_core_objects(l_shadow_balance_type_id).core_object_id;
1386: --
1387: -- Insert the defined balance row.
1388: --
1389: pay_defined_balances_pkg.insert_row
1390: (x_rowid => l_rowid
1391: ,x_defined_balance_id => l_defined_balance_id
1392: ,x_business_group_id => p_business_group_id
1393: ,x_legislation_code => null

Line 3506: from pay_defined_balances

3502: cursor csr_defined_balances_lock(p_defined_balance_id in number) is
3503: select defined_balance_id
3504: , rowid
3505: , null
3506: from pay_defined_balances
3507: where defined_balance_id = p_defined_balance_id
3508: for update of defined_balance_id;
3509: --
3510: cursor csr_element_types_lock(p_element_type_id in number) is

Line 4083: pay_defined_balances_pkg.delete_row

4079: i := p_rowid_id_recs.first;
4080: loop
4081: exit when not p_rowid_id_recs.exists(i);
4082: --
4083: pay_defined_balances_pkg.delete_row
4084: (x_rowid => p_rowid_id_recs(i).rowid
4085: ,x_defined_balance_id => p_rowid_id_recs(i).id
4086: );
4087: --