DBA Data[Home] [Help]

APPS.GHR_MASS_CON_PROGRAM dependencies on PER_ASSIGNMENTS_F

Line 1133: p_assignment_id in per_assignments_f.assignment_id%TYPE,

1129: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
1130: p_effective_date in date,
1131: p_nte_date in varchar2,
1132: p_person_id in per_people_f.person_id%TYPE,
1133: p_assignment_id in per_assignments_f.assignment_id%TYPE,
1134: p_position_id in hr_positions_f.position_id%TYPE,
1135: p_location_id in hr_locations.location_id%TYPE,
1136: p_business_group_id in number,
1137: p_errbuf out nocopy varchar2, --\ error log

Line 1889: FROM per_assignments_f paf,

1885: paf.location_id LOCATION_ID,
1886: paf.organization_id ORGANIZATION_ID,
1887: paf.business_group_id BUSINESS_GROUP_ID,
1888: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
1889: FROM per_assignments_f paf,
1890: per_people_f ppf,
1891: per_person_types ppt,
1892: hr_organization_units hou
1893: WHERE ppf.person_id = paf.person_id

Line 1939: FROM per_assignments_f paf,

1935: paf.location_id LOCATION_ID,
1936: paf.organization_id ORGANIZATION_ID,
1937: paf.business_group_id BUSINESS_GROUP_ID,
1938: paf.assignment_status_type_id ASSIGNMENT_STATUS_TYPE_ID
1939: FROM per_assignments_f paf,
1940: per_people_f ppf,
1941: per_person_types ppt,
1942: hr_organization_units hou,
1943: per_assignment_status_types past