APPS.PAY_UCI_BUS dependencies on PAY_USER_COLUMNS

Line 659: -- Validates that the user_column_id exists in pay_user_columns

655: -- |--------------------------< chk_user_column_id >--------------------------|
656: -- ----------------------------------------------------------------------------
657: --
658: -- Description:
659: -- Validates that the user_column_id exists in pay_user_columns
660: --
661: -- Pre-Requisites:
662: -- None
663: --

Line 690: from pay_user_columns puc

686: ) is
687: --
688: cursor csr_user_column_id is
689: select puc.legislation_code , puc.business_group_id
690: from pay_user_columns puc
691: where puc.user_column_id = p_user_column_id ;
692: --
693: l_busgrpid PAY_USER_COLUMNS.BUSINESS_GROUP_ID%TYPE;
694: l_legcode PAY_USER_COLUMNS.LEGISLATION_CODE%TYPE;

Line 693: l_busgrpid PAY_USER_COLUMNS.BUSINESS_GROUP_ID%TYPE;

689: select puc.legislation_code , puc.business_group_id
690: from pay_user_columns puc
691: where puc.user_column_id = p_user_column_id ;
692: --
693: l_busgrpid PAY_USER_COLUMNS.BUSINESS_GROUP_ID%TYPE;
694: l_legcode PAY_USER_COLUMNS.LEGISLATION_CODE%TYPE;
695:
696: l_proc varchar2(100) := g_package || 'chk_user_column_id';
697: begin

Line 694: l_legcode PAY_USER_COLUMNS.LEGISLATION_CODE%TYPE;

690: from pay_user_columns puc
691: where puc.user_column_id = p_user_column_id ;
692: --
693: l_busgrpid PAY_USER_COLUMNS.BUSINESS_GROUP_ID%TYPE;
694: l_legcode PAY_USER_COLUMNS.LEGISLATION_CODE%TYPE;
695:
696: l_proc varchar2(100) := g_package || 'chk_user_column_id';
697: begin
698:

Line 907: l_formula_id PAY_USER_COLUMNS.FORMULA_ID%TYPE;

903: ,p_effective_date in date
904: ) is
905: --
906:
907: l_formula_id PAY_USER_COLUMNS.FORMULA_ID%TYPE;
908: l_min_esd PAY_USER_COLUMN_INSTANCES_F.EFFECTIVE_START_DATE%TYPE;
909: l_max_eed PAY_USER_COLUMN_INSTANCES_F.EFFECTIVE_END_DATE%TYPE;
910:
911: l_version_esd PAY_USER_COLUMN_INSTANCES_F.EFFECTIVE_START_DATE%TYPE;

Line 922: from pay_user_columns puc

918: l_outputs ff_exec.outputs_t;
919:
920: cursor csr_formula_id is
921: select puc.formula_id
922: from pay_user_columns puc
923: where puc.user_column_id = p_user_column_id;
924:
925: cursor csr_formula_exists is
926: select min(ff.effective_start_date) , max(ff.effective_end_date)