APPS.PQP_UK_UNION_TEMPLATE dependencies on PAY_BALANCE_TYPES

Line 72: l_bl_core_id pay_balance_types.balance_type_id%TYPE;

68: l_xx_rowid_id ROWID;
69: l_xx_unnddn_ovn pay_element_templates.object_version_number%TYPE;
70:
71:
72: l_bl_core_id pay_balance_types.balance_type_id%TYPE;
73: l_db_core_id pay_defined_balances.defined_balance_id%TYPE;
74: l_iv_core_id pay_template_core_objects.core_object_id%TYPE;
75: l_dm_baldmn_id pay_balance_dimensions.balance_dimension_id%TYPE;
76:

Line 119: FROM pay_balance_types pbt

115:
116: CURSOR csr_bl_unnbal IS
117: SELECT pbt.balance_type_id
118: ,pbt.object_version_number
119: FROM pay_balance_types pbt
120: WHERE pbt.balance_name = p_frm_union_level_balance
121: AND pbt.business_group_id = p_frm_business_group_id
122: AND (pbt.legislation_code IS NULL
123: OR

Line 572: pay_balance_types_pkg.insert_row

568: FETCH csr_get_balance_cat_id INTO l_balance_category_id;
569: CLOSE csr_get_balance_cat_id;
570:
571: l_xx_rowid_id := NULL;
572: pay_balance_types_pkg.insert_row
573: (X_Rowid => l_xx_rowid_id -- IN OUT VARCHAR2
574: ,X_Balance_Type_Id => l_bl_core_id -- IN OUT NUMBER
575: ,X_Business_Group_Id => p_frm_business_group_id -- NUMBER
576: ,X_Legislation_Code => NULL -- VARCHAR2

Line 883: FROM pay_balance_types pbts

879:
880: CURSOR csr_bt_unnbal IS
881: SELECT pbts.rowid
882: ,pbts.balance_type_id
883: FROM pay_balance_types pbts
884: WHERE pbts.balance_name = p_frm_union_level_balance
885: AND pbts.business_group_id = p_frm_business_group_id
886: AND pbts.legislation_code IS NULL;
887:

Line 950: pay_balance_types_pkg.delete_row

946: --
947: END IF;
948: CLOSE csr_bt_unnbal;
949:
950: pay_balance_types_pkg.delete_row
951: (x_rowid => row_bt_unnbal.rowid -- VARCHAR2
952: ,x_balance_type_id => row_bt_unnbal.balance_type_id -- NUMBER
953: );
954: