APPS.PQH_RBC_UTILITY dependencies on PQH_GSP_HR_TO_STAGE

Line 325: pqh_gsp_hr_to_stage.get_table_route_details

321: p_crit_cer_ovn out nocopy number) is
322: l_egl_tr_id number;
323: l_egl_tr_name varchar2(80);
324: begin
325: pqh_gsp_hr_to_stage.get_table_route_details
326: (p_table_alias => 'EGL',
327: p_table_route_id => l_egl_tr_id,
328: p_table_name => l_egl_tr_name);
329:

Line 403: pqh_gsp_hr_to_stage.get_table_route_details

399: -- get new ben_eligy_criteria sequence --NOT NEEDED BCOZ WE USE API TO CREATE
400:
401: select BEN_ELIGY_CRITERIA_S.NEXTVAL into l_ben_eligy_criteria from dual;
402:
403: pqh_gsp_hr_to_stage.get_table_route_details
404: (p_table_alias => 'EGL',
405: p_table_route_id => l_egl_tr_id,
406: p_table_name => l_egl_tr_name);
407: hr_utility.set_location('table route is'||l_egl_tr_name,10);

Line 517: pqh_gsp_hr_to_stage.get_table_route_details

513: l_egl_tr_name varchar2(80);
514: l_egl_cer_id number;
515: l_egl_ovn number;
516: begin
517: pqh_gsp_hr_to_stage.get_table_route_details
518: (p_table_alias => 'EGL',
519: p_table_route_id => l_egl_tr_id,
520: p_table_name => l_egl_tr_name);
521: hr_utility.set_location('table route is'||l_egl_tr_name,10);

Line 1508: pqh_gsp_hr_to_stage.get_table_route_details

1504: If l_order_num is null then
1505: l_order_num := 0;
1506: End if;
1507: --
1508: pqh_gsp_hr_to_stage.get_table_route_details
1509: (p_table_alias => 'RCR',
1510: p_table_route_id => l_rcr_tr_id,
1511: p_table_name => l_rcr_tr_name);
1512: --