DBA Data[Home] [Help]

APPS.PA_HR_UPDATE_API dependencies on PA_R_PROJECT_RESOURCES_IND_V

Line 1605: FROM pa_r_project_resources_ind_v ind

1601: ind.person_id
1602: ,ind.assignment_start_date
1603: ,ind.assignment_end_date
1604: ,to_number(hoi.org_information1) default_OU
1605: FROM pa_r_project_resources_ind_v ind
1606: ,hr_organization_information hoi
1607: WHERE ind.organization_id =
1608: /* Changed for Bug 2499051- l_organization_id */ hoi.organization_id
1609: AND ind.assignment_end_date >= sysdate

Line 2073: FROM pa_r_project_resources_ind_v ind

2069:
2070: CURSOR get_all_resource(l_organization_id Hr_Organization_Information.Organization_id%type) is
2071:
2072: SELECT distinct ind.person_id
2073: FROM pa_r_project_resources_ind_v ind
2074: ,hr_organization_information hoi
2075: WHERE ind.organization_id =
2076: /* Changed for Bug 2499051- l_organization_id */ hoi.organization_id
2077: AND ind.assignment_end_date >= sysdate