APPS.PQH_RBC_STAGE dependencies on PQH_GSP_HR_TO_STAGE

Line 1118: pqh_gsp_hr_to_stage.get_table_route_details

1114: l_rbr_tr_name varchar2(150);
1115:
1116: begin
1117: hr_utility.set_location('inside recalc',10);
1118: pqh_gsp_hr_to_stage.get_table_route_details
1119: (p_table_alias => 'RBR',
1120: p_table_route_id => l_rbr_tr_id,
1121: p_table_name => l_rbr_tr_name);
1122: hr_utility.set_location('tr name is '||l_rbr_tr_name,10);

Line 1154: pqh_gsp_hr_to_stage.get_table_route_details

1150: l_rbr_tr_name varchar2(150);
1151: l_rbr_cer_id number;
1152: begin
1153: hr_utility.set_location('inside build_matx',10);
1154: pqh_gsp_hr_to_stage.get_table_route_details
1155: (p_table_alias => 'RBR',
1156: p_table_route_id => l_rbr_tr_id,
1157: p_table_name => l_rbr_tr_name);
1158: hr_utility.set_location('tr name is '||l_rbr_tr_name,10);

Line 1211: pqh_gsp_hr_to_stage.get_table_route_details

1207: when others then
1208: hr_utility.set_location('Rate retrival issue ',20);
1209: raise;
1210: end;
1211: pqh_gsp_hr_to_stage.get_table_route_details
1212: (p_table_alias => 'RMR',
1213: p_table_route_id => l_rmr_tr_id,
1214: p_table_name => l_rmr_tr_name);
1215: hr_utility.set_location('rmr tr name is '||l_rmr_tr_name,10);

Line 1457: pqh_gsp_hr_to_stage.get_table_route_details

1453: and p_effective_date between effective_start_date and effective_end_date;
1454: begin
1455: for pl_row in c1 loop
1456: hr_utility.set_location('for copying matx plan row',10);
1457: pqh_gsp_hr_to_stage.get_table_route_details
1458: (p_table_alias => 'PLN',
1459: p_table_route_id => l_pln_tr_id,
1460: p_table_name => l_pln_tr_name);
1461: hr_utility.set_location('tr name is '||l_pln_tr_name,10);

Line 1463: pqh_gsp_hr_to_stage.get_table_route_details

1459: p_table_route_id => l_pln_tr_id,
1460: p_table_name => l_pln_tr_name);
1461: hr_utility.set_location('tr name is '||l_pln_tr_name,10);
1462:
1463: pqh_gsp_hr_to_stage.get_table_route_details
1464: (p_table_alias => 'RMN',
1465: p_table_route_id => l_rmn_tr_id,
1466: p_table_name => l_rmn_tr_name);
1467: hr_utility.set_location('tr name is '||l_rmn_tr_name,10);

Line 1469: pqh_gsp_hr_to_stage.get_table_route_details

1465: p_table_route_id => l_rmn_tr_id,
1466: p_table_name => l_rmn_tr_name);
1467: hr_utility.set_location('tr name is '||l_rmn_tr_name,10);
1468:
1469: pqh_gsp_hr_to_stage.get_table_route_details
1470: (p_table_alias => 'RCR',
1471: p_table_route_id => l_rcr_tr_id,
1472: p_table_name => l_rcr_tr_name);
1473: hr_utility.set_location('tr name is '||l_rcr_tr_name,10);

Line 1689: pqh_gsp_hr_to_stage.get_table_route_details

1685:
1686: --
1687: begin
1688: hr_utility.set_location('inside plan dtl copy ',10);
1689: pqh_gsp_hr_to_stage.get_table_route_details
1690: (p_table_alias => 'RBC_CRIT',
1691: p_table_route_id => l_crt_tr_id,
1692: p_table_name => l_crt_tr_name);
1693: hr_utility.set_location('rbc_crit tr name is '||l_crt_tr_name,10);

Line 1695: pqh_gsp_hr_to_stage.get_table_route_details

1691: p_table_route_id => l_crt_tr_id,
1692: p_table_name => l_crt_tr_name);
1693: hr_utility.set_location('rbc_crit tr name is '||l_crt_tr_name,10);
1694:
1695: pqh_gsp_hr_to_stage.get_table_route_details
1696: (p_table_alias => 'RMN',
1697: p_table_route_id => l_rmn_tr_id,
1698: p_table_name => l_rmn_tr_name);
1699: hr_utility.set_location('rmn tr name is '||l_rmn_tr_name,10);

Line 1701: pqh_gsp_hr_to_stage.get_table_route_details

1697: p_table_route_id => l_rmn_tr_id,
1698: p_table_name => l_rmn_tr_name);
1699: hr_utility.set_location('rmn tr name is '||l_rmn_tr_name,10);
1700:
1701: pqh_gsp_hr_to_stage.get_table_route_details
1702: (p_table_alias => 'RMV',
1703: p_table_route_id => l_rnv_tr_id,
1704: p_table_name => l_rnv_tr_name);
1705: hr_utility.set_location('rnv tr name is '||l_rnv_tr_name,10);

Line 1707: pqh_gsp_hr_to_stage.get_table_route_details

1703: p_table_route_id => l_rnv_tr_id,
1704: p_table_name => l_rnv_tr_name);
1705: hr_utility.set_location('rnv tr name is '||l_rnv_tr_name,10);
1706:
1707: pqh_gsp_hr_to_stage.get_table_route_details
1708: (p_table_alias => 'RMR',
1709: p_table_route_id => l_rmr_tr_id,
1710: p_table_name => l_rmr_tr_name);
1711: hr_utility.set_location('rmr tr name is '||l_rmr_tr_name,10);