DBA Data[Home] [Help]

APPS.HR_ACCRUAL_PLAN_API dependencies on PAY_DEFINED_BALANCES

Line 341: pay_defined_balances dfb,

337: select distinct dbi.user_name
338: from ff_database_items dbi,
339: ff_user_entities ue,
340: pay_balance_dimensions pbd,
341: pay_defined_balances dfb,
342: pay_balance_types pbt
343: where dfb.balance_dimension_id = pbd.balance_dimension_id
344: and pbd.route_id = ue.route_id
345: and ue.user_entity_id = dbi.user_entity_id

Line 1510: -- pay_balance_feeds, pay_balace_types, and pay_defined_balances. We will

1506: l_effective_end_date := hr_general.end_of_time;
1507:
1508: --
1509: -- Now set up the balance information. This requires rows to be inserted in
1510: -- pay_balance_feeds, pay_balace_types, and pay_defined_balances. We will
1511: -- make use of the seeded balance dimension, route etc.
1512: --
1513:
1514: open c_get_leg_bal_cat_id(l_leg_code);

Line 1582: pay_defined_balances_pkg.Insert_Row(

1578: );
1579:
1580: hr_utility.set_location(l_proc, 190);
1581:
1582: pay_defined_balances_pkg.Insert_Row(
1583: X_Rowid => l_rowid,
1584: X_Defined_Balance_Id => l_defined_balance_id,
1585: X_Business_Group_Id => p_business_group_id,
1586: X_Legislation_Code => l_leg_code,

Line 2590: -- pay_balance_feeds, pay_balace_types, and pay_defined_balances. We will

2586:
2587: hr_utility.trace('l_user: '||l_user);
2588: --
2589: -- Now set up the balance information. This requires rows to be inserted in
2590: -- pay_balance_feeds, pay_balace_types, and pay_defined_balances. We will
2591: -- make use of the seeded balance dimension, route etc.
2592: --
2593: l_leg_code := null;
2594: l_balance_name := substr(l_plan_rec.accrual_plan_name||' Balance', 1, 80);

Line 2670: pay_defined_balances_pkg.Insert_Row(

2666: );
2667:
2668: hr_utility.set_location(l_proc, 110);
2669:
2670: pay_defined_balances_pkg.Insert_Row(
2671: X_Rowid => l_rowid,
2672: X_Defined_Balance_Id => l_plan_rec.defined_balance_id,
2673: X_Business_Group_Id => l_plan_rec.business_group_id,
2674: X_Legislation_Code => l_leg_code,