APPS.PAY_CA_ARCHIVE dependencies on PAY_DEFINED_BALANCES

Line 470: pay_defined_balances pdb,

466: cursor cur_get_def_bal_id is
467: select
468: pdb.defined_balance_id
469: from
470: pay_defined_balances pdb,
471: pay_balance_types pbt,
472: pay_balance_dimensions pbd1
473: where
474: pbt.balance_name = p_balance_name and

Line 483: l_def_balance_id pay_defined_balances.defined_balance_id%TYPE;

479: pbd1.dimension_name = p_dimension_name and
480: pbd1.business_group_id is null and
481: pbd1.legislation_code = 'CA';
482:
483: l_def_balance_id pay_defined_balances.defined_balance_id%TYPE;
484:
485: begin
486:
487: hr_utility.trace('Function get_defined_balance_id starts here !');

Line 2102: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

2098: l_roe_contact_phone_number pay_payrolls_f.prl_information2%TYPE;
2099: l_roe_issuer pay_payrolls_f.prl_information4%TYPE;
2100: l_roe_correspondence_language per_people_f.full_name%TYPE;
2101: l_pay_period_end_date date;
2102: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
2103: l_latest_aaid pay_assignment_actions.assignment_action_id%TYPE
2104: := 0;
2105: l_latest_aaid_after_term pay_assignment_actions.assignment_action_id%TYPE
2106: := 0;