DBA Data[Home] [Help]

APPS.PAY_MX_SUA_MAG dependencies on PER_ASSIGNMENTS_F

Line 773: per_assignments_f paf

769:
770: CURSOR csr_person (cp_asg_act_id number) IS
771: SELECT DISTINCT paf.person_id
772: FROM pay_assignment_actions paa,
773: per_assignments_f paf
774: WHERE paf.assignment_id = paa.assignment_id
775: AND paa.assignment_action_id = cp_asg_act_id;
776:
777: CURSOR csr_asg_actions (cp_person_id number) IS

Line 789: per_assignments_f paf

785: pay_mx_utility.get_legi_param_val('END_DATE',
786: ppa.legislative_parameters))
787: FROM pay_payroll_actions ppa,
788: pay_assignment_actions paa,
789: per_assignments_f paf
790: WHERE ppa.payroll_action_id = paa.payroll_action_id
791: AND paa.assignment_id = paf.assignment_id
792: AND paf.person_id = cp_person_id
793: AND fnd_date.canonical_to_date(