APPS.HR_USER_INIT_EARN dependencies on PAY_BALANCE_FEEDS_F

Line 3501: FROM pay_balance_feeds_f f,

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

Line 3546: from pay_balance_feeds_f

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

Line 3599: from pay_balance_feeds_f

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

Line 3646: FROM pay_balance_feeds_f f,

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

Line 3686: from pay_balance_feeds_f

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

Line 3739: from pay_balance_feeds_f

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