DBA Data[Home] [Help]

APPS.PAY_SG_SOE dependencies on PAY_USER_COLUMNS

Line 856: p_business_group_id in pay_user_columns.business_group_id%type )

852: function get_exchange_rate
853: (p_from_currency in gl_daily_rates.from_currency%type,
854: p_to_currency in gl_daily_rates.to_currency%type,
855: eff_date in gl_daily_rates.conversion_date%type,
856: p_business_group_id in pay_user_columns.business_group_id%type )
857: return number is
858: CURSOR rate is SELECT gdr.conversion_rate
859: FROM gl_daily_rates gdr, gl_daily_conversion_types gdct
860: WHERE gdr.conversion_type = gdct.conversion_type

Line 868: pay_user_columns puc,

864: AND gdct.user_conversion_type = (
865: SELECT puci.value
866: FROM pay_user_column_instances_f puci,
867: pay_user_rows_f pur,
868: pay_user_columns puc,
869: pay_user_tables put
870: WHERE puci.user_row_id = pur.user_row_id
871: AND puci.user_column_id = puc.user_column_id
872: AND pur.user_table_id = put.user_table_id