APPS.PAY_SE_FORA dependencies on PAY_ASSIGNMENT_ACTIONS

Line 446: FROM pay_Assignment_actions WHERE

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

Line 553: l_assignment_id pay_Assignment_actions.assignment_id%type;

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

Line 554: l_assignment_action_id pay_Assignment_actions.assignment_action_id%type;

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