APPS.PQH_CPD_HR_TO_STAGE dependencies on PQH_GSP_HR_TO_STAGE

Line 352: pqh_gsp_hr_to_stage.get_table_route_details

348: hr_utility.set_location('pth hier ver'||l_hierarchy_version_id,10);
349: if l_hierarchy_version_id is null then
350: l_continue := FALSE;
351: end if;
352: pqh_gsp_hr_to_stage.get_table_route_details
353: (p_table_alias => 'CRPATH',
354: p_table_route_id => l_pth_tr_id,
355: p_table_name => l_pth_tr_name);
356: hr_utility.set_location('pth tr name'||l_pth_tr_name,20);

Line 449: pqh_gsp_hr_to_stage.get_table_route_details

445: where corps_definition_id = p_corps_definition_id
446: and information_type = 'DOCUMENT';
447: begin
448: hr_utility.set_location('inside cdd create',10);
449: pqh_gsp_hr_to_stage.get_table_route_details
450: (p_table_alias => 'CORPS_DOC',
451: p_table_route_id => l_cdd_tr_id,
452: p_table_name => l_cdd_tr_name);
453: hr_utility.set_location('cdd tr name'||l_cdd_tr_name,20);

Line 520: pqh_gsp_hr_to_stage.get_table_route_details

516: l_review_period number;
517: begin
518: hr_utility.set_location('inside corps_to_stage',10);
519: for cpd_rec in csr_cpd_rec loop
520: pqh_gsp_hr_to_stage.get_table_route_details
521: (p_table_alias => 'CPD',
522: p_table_route_id => l_cpd_tr_id,
523: p_table_name => l_cpd_tr_name);
524: hr_utility.set_location('cpd tr name'||l_cpd_tr_name,20);