APPS.PAY_US_REPORTING_UTILS_PKG dependencies on PAY_BALANCE_TYPES

Line 2817: l_balance_name pay_balance_types.balance_name%TYPE;

2813:
2814: lv_bal_amt number := 0;
2815: l_bal_id number := 0;
2816: l_get boolean := TRUE ;
2817: l_balance_name pay_balance_types.balance_name%TYPE;
2818: l_effective_start_date pay_payroll_actions.effective_date%TYPE;
2819: l_effective_end_date pay_payroll_actions.effective_date%TYPE;
2820: l_exists varchar2(1);
2821:

Line 2831: CURSOR get_balance_feed_exist(c_balance_name pay_balance_types.balance_name%TYPE,

2827: where ppa.payroll_action_id = paa.payroll_action_id
2828: and paa.assignment_action_id = c_assignment_action_id;
2829:
2830: /*Bug:3233249*/
2831: CURSOR get_balance_feed_exist(c_balance_name pay_balance_types.balance_name%TYPE,
2832: c_start_date pay_payroll_actions.effective_date%TYPE,
2833: c_end_date pay_payroll_actions.effective_date%TYPE)
2834: IS
2835: select '1' from pay_balance_feeds_f pbf,

Line 2836: pay_balance_types pbt

2832: c_start_date pay_payroll_actions.effective_date%TYPE,
2833: c_end_date pay_payroll_actions.effective_date%TYPE)
2834: IS
2835: select '1' from pay_balance_feeds_f pbf,
2836: pay_balance_types pbt
2837: where pbf.balance_type_id = pbt.balance_type_id
2838: and pbt.balance_name = c_balance_name
2839: and pbf.effective_start_date <= c_end_date
2840: and pbf.effective_end_date >= c_start_date;