APPS.PAY_IN_TAX_DECLARATION dependencies on PAY_USER_COLUMN_INSTANCES_F

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

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

Line 489: RETURN pay_user_column_instances_f.value%TYPE

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

Line 498: , pay_user_column_instances_f cinstances

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

Line 508: l_meaning pay_user_column_instances_f.value%TYPE;

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