APPS.HR_USER_INIT_EARN dependencies on PAY_BALANCE_FEEDS_F

Line 3499: FROM pay_balance_feeds_f f,

3495: -- is automatically taken care of in the "classification balance feeder"
3496:
3497: CURSOR get_reg_feeds (p_iv_id in number) IS
3498: SELECT f.balance_type_id
3499: FROM pay_balance_feeds_f f,
3500: pay_balance_types bt
3501: WHERE f.input_value_id = p_iv_id
3502: AND p_eff_start_date between f.effective_start_date
3503: and f.effective_end_date

Line 3544: from pay_balance_feeds_f

3540: exit when get_reg_feeds%notfound;
3541:
3542: select COUNT(0)
3543: into already_exists
3544: from pay_balance_feeds_f
3545: where input_value_id = g_reduce_pay_inpval_id
3546: and balance_type_id = l_bal_id;
3547:
3548: IF already_exists = 0 THEN

Line 3597: from pay_balance_feeds_f

3593: exit when get_reg_feeds%notfound;
3594:
3595: select COUNT(0)
3596: into already_exists
3597: from pay_balance_feeds_f
3598: where input_value_id = g_reduce_pay_inpval_id
3599: and balance_type_id = l_bal_id;
3600:
3601: IF already_exists = 0 THEN

Line 3644: FROM pay_balance_feeds_f f,

3640:
3641: -- bug 962590 added FLSA Hours and FLSA Earnings check to cursor
3642: CURSOR get_reg_feeds (p_iv_id in number, p_business_group_id in number) IS
3643: SELECT f.balance_type_id
3644: FROM pay_balance_feeds_f f,
3645: pay_balance_types bt
3646: WHERE f.input_value_id = p_iv_id
3647: AND p_eff_start_date between f.effective_start_date
3648: and f.effective_end_date

Line 3684: from pay_balance_feeds_f

3680: exit when get_reg_feeds%notfound;
3681:
3682: select COUNT(0)
3683: into already_exists
3684: from pay_balance_feeds_f
3685: where input_value_id = p_iv_id
3686: and balance_type_id = l_bal_id;
3687:
3688: IF already_exists = 0 THEN

Line 3737: from pay_balance_feeds_f

3733: exit when get_reg_feeds%notfound;
3734:
3735: select COUNT(0)
3736: into already_exists
3737: from pay_balance_feeds_f
3738: where input_value_id = p_iv_id
3739: and balance_type_id = l_bal_id;
3740:
3741: IF already_exists = 0 THEN