APPS.PAY_US_REPORTING_UTILS_PKG dependencies on PAY_BALANCE_TYPES

Line 2836: l_balance_name pay_balance_types.balance_name%TYPE;

2832:
2833: lv_bal_amt number := 0;
2834: l_bal_id number := 0;
2835: l_get boolean := TRUE ;
2836: l_balance_name pay_balance_types.balance_name%TYPE;
2837: l_effective_start_date pay_payroll_actions.effective_date%TYPE;
2838: l_effective_end_date pay_payroll_actions.effective_date%TYPE;
2839: l_exists varchar2(1);
2840:

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

2846: where ppa.payroll_action_id = paa.payroll_action_id
2847: and paa.assignment_action_id = c_assignment_action_id;
2848:
2849: /*Bug:3233249*/
2850: CURSOR get_balance_feed_exist(c_balance_name pay_balance_types.balance_name%TYPE,
2851: c_start_date pay_payroll_actions.effective_date%TYPE,
2852: c_end_date pay_payroll_actions.effective_date%TYPE)
2853: IS
2854: select '1' from pay_balance_feeds_f pbf,

Line 2855: pay_balance_types pbt

2851: c_start_date pay_payroll_actions.effective_date%TYPE,
2852: c_end_date pay_payroll_actions.effective_date%TYPE)
2853: IS
2854: select '1' from pay_balance_feeds_f pbf,
2855: pay_balance_types pbt
2856: where pbf.balance_type_id = pbt.balance_type_id
2857: and pbt.balance_name = c_balance_name
2858: and pbf.effective_start_date <= c_end_date
2859: and pbf.effective_end_date >= c_start_date;