APPS.PQH_RBC_LOAD_OBJECTS dependencies on PAY_ELEMENT_TYPES_F

Line 1187: l_element_type_id pay_element_types_f.element_type_id%type;

1183: l_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;
1184: l_parent_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;
1185: l_criteria_rate_factor_id pqh_criteria_rate_factors.criteria_rate_factor_id%type ;
1186:
1187: l_element_type_id pay_element_types_f.element_type_id%type;
1188: l_criteria_rate_element_id pqh_criteria_rate_elements.criteria_rate_element_id%type;
1189:
1190: l_rate_factor_on_elmnt_id pqh_rate_factor_on_elmnts.rate_factor_on_elmnt_id%TYPE;
1191: l_rate_factor_val_record_col pqh_rate_factor_on_elmnts.rate_factor_val_record_col%type;

Line 1227: select element_type_id from pay_element_types_f

1223: and parent_criteria_rate_defn_id = crdp_id
1224: and business_group_id = l_business_group_id;
1225:
1226: Cursor csr_ele is
1227: select element_type_id from pay_element_types_f
1228: where element_name = p_element_type_name
1229: and l_effective_date between effective_start_date and effective_end_date
1230: and (business_group_id = l_business_group_id OR (legislation_code in
1231: (select legislation_code from per_business_groups_perf where business_group_id = l_business_group_id)

Line 1379: l_element_type_id pay_element_types_f.element_type_id%type;

1375: ,p_effective_start_date in VARCHAR2
1376: ) is
1377:
1378: l_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;
1379: l_element_type_id pay_element_types_f.element_type_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;

Line 1402: select element_type_id from pay_element_types_f

1398: and business_group_id = l_business_group_id;
1399: --
1400:
1401: Cursor csr_ele is
1402: select element_type_id from pay_element_types_f
1403: where element_name = p_element_type_name
1404: and l_effective_date between effective_start_date and effective_end_date
1405: and (business_group_id = l_business_group_id OR (legislation_code in
1406: (select legislation_code from per_business_groups_perf where business_group_id = l_business_group_id)

Line 1530: l_element_type_id pay_element_types_f.element_type_id%type;

1526: ,p_effective_start_date in varchar2
1527: ) is
1528: --
1529: l_criteria_rate_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type ;
1530: l_element_type_id pay_element_types_f.element_type_id%type;
1531: l_criteria_rate_element_id pqh_criteria_rate_elements.criteria_rate_element_id%type;
1532: l_rel_element_type_id pqh_rate_element_relations.rel_element_type_id%type;
1533: l_rel_input_value_id pqh_rate_element_relations.rel_input_value_id%type;
1534: l_relation_type_cd pqh_rate_element_relations.relation_type_cd%type;

Line 1561: select element_type_id from pay_element_types_f

1557: and business_group_id = l_business_group_id;
1558: --
1559:
1560: Cursor csr_ele is
1561: select element_type_id from pay_element_types_f
1562: where element_name = p_element_type_name
1563: and l_effective_date between effective_start_date and effective_end_date
1564: and (business_group_id = l_business_group_id OR (legislation_code in
1565: (select legislation_code from per_business_groups_perf where business_group_id = l_business_group_id)

Line 1579: select element_type_id from pay_element_types_f

1575:
1576: --
1577: --
1578: Cursor csr_rel_ele is
1579: select element_type_id from pay_element_types_f
1580: where element_name = p_rel_element_name
1581: and l_effective_date between effective_start_date and effective_end_date
1582: and business_group_id = l_business_group_id;
1583: