APPS.PQP_GB_PROFESSIONAL_BODY_TEMP dependencies on PAY_BALANCE_TYPES

Line 64: l_bl_core_id pay_balance_types.balance_type_id%TYPE;

60:
61: -- Generic Never to be passed IN
62: l_xx_rowid_id ROWID;
63:
64: l_bl_core_id pay_balance_types.balance_type_id%TYPE;
65: l_bf_pbdbal_id pay_shadow_balance_feeds.balance_feed_id%TYPE;
66: l_db_core_id pay_defined_balances.defined_balance_id%TYPE;
67: l_iv_core_id pay_template_core_objects.core_object_id%TYPE;
68: l_dm_baldmn_id pay_balance_dimensions.balance_dimension_id%TYPE;

Line 104: FROM pay_balance_types pbt

100:
101: CURSOR csr_get_pb_balid IS
102: SELECT pbt.balance_type_id
103: ,pbt.object_version_number
104: FROM pay_balance_types pbt
105: WHERE pbt.balance_name = p_professional_body_level_bal
106: AND pbt.business_group_id = p_bg_id
107: AND (pbt.legislation_code IS NULL
108: OR

Line 436: pay_balance_types_pkg.insert_row

432: FETCH csr_get_balance_cat_id INTO l_balance_category_id;
433: CLOSE csr_get_balance_cat_id;
434:
435: l_xx_rowid_id := NULL;
436: pay_balance_types_pkg.insert_row
437: (X_Rowid => l_xx_rowid_id -- IN OUT VARCHAR2
438: ,X_Balance_Type_Id => l_bl_core_id -- IN OUT NUMBER
439: ,X_Business_Group_Id => p_bg_id -- NUMBER
440: ,X_Legislation_Code => NULL -- VARCHAR2

Line 695: FROM pay_balance_types pbts

691:
692: CURSOR csr_get_pb_balid IS
693: SELECT pbts.rowid
694: ,pbts.balance_type_id
695: FROM pay_balance_types pbts
696: WHERE pbts.balance_name = p_professional_body_level_bal
697: AND pbts.business_group_id = p_business_group_id
698: AND pbts.legislation_code IS NULL;
699:

Line 778: pay_balance_types_pkg.delete_row

774: CLOSE csr_get_pb_balid;
775:
776: hr_utility.set_location(l_proc, 70);
777:
778: pay_balance_types_pkg.delete_row
779: (x_rowid => csr_get_pb_balid_rec.rowid -- VARCHAR2
780: ,x_balance_type_id => csr_get_pb_balid_rec.balance_type_id -- NUMBER
781: );
782: