APPS.PAY_ELEMENT_TEMPLATE_GEN dependencies on PAY_DEFINED_BALANCES

Line 750: from pay_defined_balances

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

Line 1376: pay_defined_balances_pkg.insert_row

1372: p_sbt_core_objects(l_shadow_balance_type_id).core_object_id;
1373: --
1374: -- Insert the defined balance row.
1375: --
1376: pay_defined_balances_pkg.insert_row
1377: (x_rowid => l_rowid
1378: ,x_defined_balance_id => l_defined_balance_id
1379: ,x_business_group_id => p_business_group_id
1380: ,x_legislation_code => null

Line 3488: from pay_defined_balances

3484: cursor csr_defined_balances_lock(p_defined_balance_id in number) is
3485: select defined_balance_id
3486: , rowid
3487: , null
3488: from pay_defined_balances
3489: where defined_balance_id = p_defined_balance_id
3490: for update of defined_balance_id;
3491: --
3492: cursor csr_element_types_lock(p_element_type_id in number) is

Line 4065: pay_defined_balances_pkg.delete_row

4061: i := p_rowid_id_recs.first;
4062: loop
4063: exit when not p_rowid_id_recs.exists(i);
4064: --
4065: pay_defined_balances_pkg.delete_row
4066: (x_rowid => p_rowid_id_recs(i).rowid
4067: ,x_defined_balance_id => p_rowid_id_recs(i).id
4068: );
4069: --