APPS.PSP_LABOR_DIST dependencies on PER_ASSIGNMENTS_F

Line 28: per_assignments_f paf,per_people_f ppf

24: CURSOR assign_num_cur IS
25: SELECT paf.assignment_number,
26: ppf.employee_number
27: FROM
28: per_assignments_f paf,per_people_f ppf
29: WHERE paf.assignment_id =p_assignment_id
30: AND paf.person_id =ppf.person_id
31: and paf.assignment_type = 'E'
32: AND p_payroll_start_date between paf.effective_start_date and paf.effective_end_date

Line 3083: FROM per_assignments_f paf,

3079: decode(g_dff_grouping_option, 'Y',NVL(p_attribute7, pdls.attribute7)) attribute7,
3080: decode(g_dff_grouping_option, 'Y',NVL(p_attribute8, pdls.attribute8)) attribute8,
3081: decode(g_dff_grouping_option, 'Y',NVL(p_attribute9, pdls.attribute9)) attribute9,
3082: decode(g_dff_grouping_option, 'Y',NVL(p_attribute10, pdls.attribute10)) attribute10
3083: FROM per_assignments_f paf,
3084: psp_default_labor_schedules pdls
3085: WHERE pdls.business_group_id = p_business_group_id
3086: AND pdls.set_of_books_id = p_set_of_books_id
3087: and paf.assignment_type = 'E'

Line 3624: FROM per_assignments_f paf,

3620: decode(g_dff_grouping_option, 'Y',NVL(p_attribute7, poa.attribute7)) attribute7,
3621: decode(g_dff_grouping_option, 'Y',NVL(p_attribute8, poa.attribute8)) attribute8,
3622: decode(g_dff_grouping_option, 'Y',NVL(p_attribute9, poa.attribute9)) attribute9,
3623: decode(g_dff_grouping_option, 'Y',NVL(p_attribute10, poa.attribute10)) attribute10
3624: FROM per_assignments_f paf,
3625: psp_organization_accounts poa
3626: WHERE poa.business_group_id = p_business_group_id
3627: AND poa.set_of_books_id = p_set_of_books_id
3628: and paf.assignment_type = 'E'

Line 4004: per_assignments_f paf

4000: P_ASSIGNMENT_ID IN NUMBER) IS
4001: SELECT hou.organization_id,
4002: hou.name
4003: FROM hr_organization_units hou,
4004: per_assignments_f paf
4005: WHERE paf.business_group_id = p_business_group_id
4006: AND paf.assignment_id = p_assignment_id
4007: and paf.assignment_type = 'E'
4008: AND paf.business_group_id = hou.business_group_id