APPS.PAY_IN_TAX_DECLARATION dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 481: -- RETURN : pay_user_column_instances_f.value%TYPE --

477: -- is used to validate the same in self-service --
478: -- --
479: -- Parameters : --
480: -- IN : p_lookup_code VARCHAR2 --
481: -- RETURN : pay_user_column_instances_f.value%TYPE --
482: -- --
483: -- Change History : --
484: --------------------------------------------------------------------------
485: -- Rev# Date Userid Description --

Line 490: RETURN pay_user_column_instances_f.value%TYPE

486: --------------------------------------------------------------------------
487: -- 1.0 24-Sep-2004 PUCHIL Initial Version --
488: --------------------------------------------------------------------------
489: FUNCTION get_donation_type(p_lookup_code IN VARCHAR2)
490: RETURN pay_user_column_instances_f.value%TYPE
491: IS
492: --
493: CURSOR csr_get_meaning
494: IS

Line 499: , pay_user_column_instances_f cinstances

495: SELECT cinstances.value
496: FROM pay_user_tables utab
497: , pay_user_columns ucols
498: , pay_user_rows_f urows
499: , pay_user_column_instances_f cinstances
500: WHERE utab.user_table_id = ucols.user_table_id
501: AND utab.user_table_id = urows.user_table_id
502: AND ucols.user_column_id = cinstances.user_column_id
503: AND urows.user_row_id = cinstances.user_row_id

Line 509: l_meaning pay_user_column_instances_f.value%TYPE;

505: AND utab.legislation_code = 'IN'
506: AND ucols.user_column_name = 'Donation Type'
507: AND urows.row_low_range_or_name = p_lookup_code;
508: --
509: l_meaning pay_user_column_instances_f.value%TYPE;
510: l_procedure VARCHAR(100);
511: l_message VARCHAR2(250);
512:
513: --