DBA Data[Home] [Help]

APPS.PAY_MX_SUA_MAG dependencies on PER_ASSIGNMENTS_F

Line 888: per_assignments_f paf

884:
885: CURSOR csr_person (cp_asg_act_id number) IS
886: SELECT DISTINCT paf.person_id
887: FROM pay_assignment_actions paa,
888: per_assignments_f paf
889: WHERE paf.assignment_id = paa.assignment_id
890: AND paa.assignment_action_id = cp_asg_act_id;
891:
892: CURSOR csr_asg_actions (cp_person_id number) IS

Line 904: per_assignments_f paf

900: pay_mx_utility.get_legi_param_val('END_DATE',
901: ppa.legislative_parameters))
902: FROM pay_payroll_actions ppa,
903: pay_assignment_actions paa,
904: per_assignments_f paf
905: WHERE ppa.payroll_action_id = paa.payroll_action_id
906: AND paa.assignment_id = paf.assignment_id
907: AND paf.person_id = cp_person_id
908: AND fnd_date.canonical_to_date(