APPS.PAY_US_YEPP_ADD_ACTIONS_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 617: l_assignment_id per_all_assignments_f.assignment_id%type;

613: and paa.assignment_id = has.assignment_id
614: and nvl(has.include_or_exclude,'I') = 'I';
615:
616: l_bal_aaid pay_assignment_actions.assignment_action_id%type;
617: l_assignment_id per_all_assignments_f.assignment_id%type;
618: l_person_id per_all_assignments_f.person_id%type;
619: l_yepp_payroll_action_id pay_payroll_actions.payroll_action_id%type;
620: l_value number;
621: lockingactid pay_assignment_actions.assignment_action_id%type;

Line 618: l_person_id per_all_assignments_f.person_id%type;

614: and nvl(has.include_or_exclude,'I') = 'I';
615:
616: l_bal_aaid pay_assignment_actions.assignment_action_id%type;
617: l_assignment_id per_all_assignments_f.assignment_id%type;
618: l_person_id per_all_assignments_f.person_id%type;
619: l_yepp_payroll_action_id pay_payroll_actions.payroll_action_id%type;
620: l_value number;
621: lockingactid pay_assignment_actions.assignment_action_id%type;
622: l_prev_person_id per_all_assignments_f.person_id%type; -- bug 3315082

Line 622: l_prev_person_id per_all_assignments_f.person_id%type; -- bug 3315082

618: l_person_id per_all_assignments_f.person_id%type;
619: l_yepp_payroll_action_id pay_payroll_actions.payroll_action_id%type;
620: l_value number;
621: lockingactid pay_assignment_actions.assignment_action_id%type;
622: l_prev_person_id per_all_assignments_f.person_id%type; -- bug 3315082
623:
624: /* we should always be stamping the primary assignment_id, even if the
625: assignment selected in the assignment set is secondary */
626:

Line 631: from per_all_assignments_f paf

627: /* Get the primary assignment for the given person_id */
628:
629: CURSOR c_get_asg_id (p_person_id number) IS
630: SELECT assignment_id
631: from per_all_assignments_f paf
632: where person_id = p_person_id
633: and primary_flag = 'Y'
634: and assignment_type = 'E'
635: and paf.effective_start_date <= add_months(p_effective_date, 12) - 1