APPS.PAY_CA_ARCHIVE dependencies on PAY_DEFINED_BALANCES

Line 466: pay_defined_balances pdb,

462: cursor cur_get_def_bal_id is
463: select
464: pdb.defined_balance_id
465: from
466: pay_defined_balances pdb,
467: pay_balance_types pbt,
468: pay_balance_dimensions pbd1
469: where
470: pbt.balance_name = p_balance_name and

Line 479: l_def_balance_id pay_defined_balances.defined_balance_id%TYPE;

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

Line 2098: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

2094: l_roe_contact_phone_number pay_payrolls_f.prl_information2%TYPE;
2095: l_roe_issuer pay_payrolls_f.prl_information4%TYPE;
2096: l_roe_correspondence_language per_people_f.full_name%TYPE;
2097: l_pay_period_end_date date;
2098: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
2099: l_latest_aaid pay_assignment_actions.assignment_action_id%TYPE
2100: := 0;
2101: l_latest_aaid_after_term pay_assignment_actions.assignment_action_id%TYPE
2102: := 0;