APPS.PAY_SE_FORA dependencies on PAY_ASSIGNMENT_ACTIONS

Line 445: FROM pay_Assignment_actions WHERE

441: CURSOR csr_assignment_action (csr_v_payroll_action_id
442: pay_payroll_actions.payroll_action_id%type)
443: IS
444: SELECT MAX(assignment_action_id)
445: FROM pay_Assignment_actions WHERE
446: payroll_action_id=csr_v_payroll_action_id; --23
447:
448: CURSOR csr_Local_unit_Legal(csr_v_legal_unit_id
449: hr_organization_units.organization_id%TYPE)

Line 552: l_assignment_id pay_Assignment_actions.assignment_id%type;

548: l_end_date date;
549: l_termination_date date;
550: lr_Get_Defined_Balance_Id pay_defined_balances.defined_balance_id%type;
551: l_value number;
552: l_assignment_id pay_Assignment_actions.assignment_id%type;
553: l_assignment_action_id pay_Assignment_actions.assignment_action_id%type;
554: L_CFAR_NUMBER NUMBER;
555: l_legal_employer_id NUMBER;
556: l_virtual_date DATE;

Line 553: l_assignment_action_id pay_Assignment_actions.assignment_action_id%type;

549: l_termination_date date;
550: lr_Get_Defined_Balance_Id pay_defined_balances.defined_balance_id%type;
551: l_value number;
552: l_assignment_id pay_Assignment_actions.assignment_id%type;
553: l_assignment_action_id pay_Assignment_actions.assignment_action_id%type;
554: L_CFAR_NUMBER NUMBER;
555: l_legal_employer_id NUMBER;
556: l_virtual_date DATE;
557: l_date_birth per_all_people_f.DATE_OF_BIRTH%TYPE;