APPS.PAY_US_EMPLOYEE_PAYSLIP_WEB dependencies on PER_ASSIGNMENTS_F

Line 968: from per_assignments_f paf

964: decode(paf.frequency,'Y', 1,
965: 'M', 12,
966: 'W', 52,
967: 'D', 365, 1)
968: from per_assignments_f paf
969: where paf.assignment_id = cp_assignment_id
970: and cp_period_end_date between paf.effective_start_date
971: and paf.effective_end_date;
972:

Line 981: per_assignments_f paf

977: 'M', 12,
978: 'W', 52,
979: 'D', 365, 1)
980: from per_positions pos,
981: per_assignments_f paf
982: where paf.assignment_id = cp_assignment_id
983: and cp_period_end_date between paf.effective_start_date
984: and paf.effective_end_date
985: and paf.position_id = pos.position_id;

Line 995: per_assignments_f paf

991: 'M', 12,
992: 'W', 52,
993: 'D', 365, 1)
994: from per_organization_units pou,
995: per_assignments_f paf
996: where paf.assignment_id = cp_assignment_id
997: and cp_period_end_date between paf.effective_start_date
998: and paf.effective_end_date
999: and paf.organization_id = pou.organization_id;

Line 1009: per_assignments_f paf

1005: 'M', 12,
1006: 'W', 52,
1007: 'D', 365, 1)
1008: from per_business_groups pbg,
1009: per_assignments_f paf
1010: where paf.assignment_id = cp_assignment_id
1011: and cp_period_end_date between paf.effective_start_date
1012: and paf.effective_end_date
1013: and paf.business_group_id = pbg.business_group_id;

Line 1291: from per_assignments_f paf, per_periods_of_service pps

1287:
1288: CURSOR get_person_info(l_assignment_id number) IS
1289: select paf.business_group_id, paf.organization_id,
1290: paf.location_id, paf.person_id
1291: from per_assignments_f paf, per_periods_of_service pps
1292: where paf.assignment_id = l_assignment_id
1293: and p_effective_date between paf.effective_start_date
1294: and paf.effective_end_date
1295: and pps.period_of_service_id = paf.period_of_service_id