[Home] [Help]
425:
426: cursor csr_pbad_id(p_attrib_id PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_ID%TYPE)
427: is
428: select attribute_id
429: from pay_bal_attribute_defaults
430: where attribute_id=p_attrib_id;
431:
432: --This cursor is used to select the attribute id
433: cursor csr_sel_attrib_id(p_ATTRIBUTE_NAME VARCHAR2,
766: END;
767:
768: END PAY_BAL_ATT_LOAD_ROW;
769:
770: --This procedure is used for loading data into table PAY_BAL_ATTRIBUTE_DEFAULTS
771: --This procedure is called from pybaladf.lct configuration file
772: PROCEDURE PAY_BAL_ADF_LOAD_ROW
773: (p_CATEGORY_NAME IN VARCHAR2
774: ,p_EFFECTIVE_START_DATE IN VARCHAR2
786: ,p_OWNER IN VARCHAR2
787: )IS
788:
789: l_bal_attribute_default_id
790: PAY_BAL_ATTRIBUTE_DEFAULTS.BAL_ATTRIBUTE_DEFAULT_ID%TYPE;
791: l_balance_category_id PAY_BALANCE_CATEGORIES_F.BALANCE_CATEGORY_ID%TYPE;
792: l_legislation_code PAY_BAL_ATTRIBUTE_DEFAULTS.LEGISLATION_CODE%TYPE;
793: l_attribute_id PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_ID%TYPE;
794: l_balance_dimension_id PAY_BALANCE_DIMENSIONS.BALANCE_DIMENSION_ID%TYPE;
788:
789: l_bal_attribute_default_id
790: PAY_BAL_ATTRIBUTE_DEFAULTS.BAL_ATTRIBUTE_DEFAULT_ID%TYPE;
791: l_balance_category_id PAY_BALANCE_CATEGORIES_F.BALANCE_CATEGORY_ID%TYPE;
792: l_legislation_code PAY_BAL_ATTRIBUTE_DEFAULTS.LEGISLATION_CODE%TYPE;
793: l_attribute_id PAY_BAL_ATTRIBUTE_DEFINITIONS.ATTRIBUTE_ID%TYPE;
794: l_balance_dimension_id PAY_BALANCE_DIMENSIONS.BALANCE_DIMENSION_ID%TYPE;
795: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
796: l_attr_bus_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
915: l_balance_dimension_id,
916: l_attribute_id,
917: l_legislation_code,
918: l_owner
919: FROM PAY_BAL_ATTRIBUTE_DEFAULTS
920: WHERE balance_category_id = l_balance_category_id
921: AND attribute_id = l_attribute_id
922: AND balance_dimension_id =l_balance_dimension_id;
923: