APPS.PQH_RBC_LOAD_OBJECTS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 46: l_business_group_id hr_all_organization_units.business_group_id%type;

42: l_ovn number ;
43: l_effective_start_date date ;
44: l_effective_end_date date ;
45: l_effective_date date;
46: l_business_group_id hr_all_organization_units.business_group_id%type;
47: l_dt_mode varchar2(30);
48: --
49: --
50: l_created_by ben_pl_f.created_by%TYPE;

Line 183: l_business_group_id hr_all_organization_units.business_group_id%type;

179: ) is
180: --
181: l_pl_id ben_pl_f.pl_id%type ;
182: l_eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type;
183: l_business_group_id hr_all_organization_units.business_group_id%type;
184: --
185: l_rate_matrix_node_id pqh_rate_matrix_nodes.rate_matrix_node_id%type;
186: l_parent_node_id pqh_rate_matrix_nodes.parent_node_id%type;
187: l_ovn number := 1;

Line 360: l_business_group_id hr_all_organization_units.business_group_id%type;

356: ,p_effective_date in varchar2
357: ,p_owner in varchar2
358: ) is
359: --
360: l_business_group_id hr_all_organization_units.business_group_id%type;
361: l_rate_matrix_node_id pqh_rate_matrix_nodes.rate_matrix_node_id%type;
362: --
363: l_node_value_id pqh_rt_matrix_node_values.node_value_id%type;
364: l_ovn number := 1;

Line 535: l_business_group_id hr_all_organization_units.business_group_id%type;

531: l_ovn number := 1;
532: l_effective_start_date date ;
533: l_effective_end_date date ;
534: l_effective_date date;
535: l_business_group_id hr_all_organization_units.business_group_id%type;
536: l_dt_mode varchar2(30);
537: --
538: --
539: l_created_by ben_pl_f.created_by%TYPE;

Line 809: l_business_group_id hr_all_organization_units.business_group_id%type;

805: --
806: l_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;
807: l_ovn number := 1;
808: l_effective_date date;
809: l_business_group_id hr_all_organization_units.business_group_id%type;
810: --
811: --
812: l_created_by pqh_criteria_rate_defn.created_by%TYPE;
813: l_last_updated_by pqh_criteria_rate_defn.last_updated_by%TYPE;

Line 1045: l_business_group_id hr_all_organization_units.business_group_id%type;

1041: l_parent_rate_matrix_id pqh_criteria_rate_factors.parent_rate_matrix_id%type ;
1042:
1043: l_effective_date Date;
1044: l_object_version_number number := 1;
1045: l_business_group_id hr_all_organization_units.business_group_id%type;
1046: --
1047: --
1048: l_created_by pqh_criteria_rate_factors.created_by%TYPE;
1049: l_last_updated_by pqh_criteria_rate_factors.last_updated_by%TYPE;

Line 1195: l_business_group_id hr_all_organization_units.business_group_id%type;

1191: l_rate_factor_val_record_col pqh_rate_factor_on_elmnts.rate_factor_val_record_col%type;
1192:
1193: l_effective_date Date;
1194: l_object_version_number number := 1;
1195: l_business_group_id hr_all_organization_units.business_group_id%type;
1196: --
1197: --
1198: l_created_by pqh_rate_factor_on_elmnts.created_by%TYPE;
1199: l_last_updated_by pqh_rate_factor_on_elmnts.last_updated_by%TYPE;

Line 1384: l_business_group_id hr_all_organization_units.business_group_id%type;

1380: l_input_value_id pay_input_values_f.input_value_id%type;
1381: l_criteria_rate_element_id pqh_criteria_rate_elements.criteria_rate_element_id%type;
1382: l_effective_date Date;
1383: l_object_version_number number := 1;
1384: l_business_group_id hr_all_organization_units.business_group_id%type;
1385: --
1386: --
1387: l_created_by pqh_criteria_rate_elements.created_by%TYPE;
1388: l_last_updated_by pqh_criteria_rate_elements.last_updated_by%TYPE;

Line 1539: l_business_group_id hr_all_organization_units.business_group_id%type;

1535: l_rate_element_relation_id pqh_rate_element_relations.rate_element_relation_id%type;
1536: l_effective_date Date;
1537:
1538: l_object_version_number number := 1;
1539: l_business_group_id hr_all_organization_units.business_group_id%type;
1540: --
1541: --
1542: l_created_by pqh_rate_element_relations.created_by%TYPE;
1543: l_last_updated_by pqh_rate_element_relations.last_updated_by%TYPE;