DBA Data[Home] [Help]

APPS.PAY_CA_EOY_ARCHIVE dependencies on PAY_DEFINED_BALANCES

Line 420: l_defined_balance_id pay_defined_balances.defined_balance_id%type;

416: and UE.user_entity_id = DI.user_entity_id
417: and Ue.creator_type = 'B'
418: and UE.legislation_code = 'CA';
419:
420: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
421:
422: begin
423:
424: open csr_defined_balance;

Line 586: l_defined_balance_id pay_defined_balances.defined_balance_id%type;

582: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
583:
584: /* Variable holding the balance to be tested. */
585:
586: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
587:
588: /* Indicator variables used to control how the people are grouped. */
589:
590: l_group_by_gre boolean := FALSE;