DBA Data[Home] [Help]

APPS.PAY_EEI_BUS dependencies on PAY_USER_TABLES

Line 625: FROM pay_user_tables put

621: -- Pay Source Value
622: -- Added for bug 4555325
623: CURSOR c_user_table_name IS
624: SELECT 'Y'
625: FROM pay_user_tables put
626: where upper(user_table_name)=UPPER(p_qualifier)
627: and (( put.business_group_id is not null
628: and put.business_group_id = nvl(l_business_group_id,put.business_group_id))
629: or ( put.legislation_code is not null

Line 827: from pay_user_columns puc, pay_user_tables put

823:
824: -- bug 4555325
825: CURSOR c_get_column_name is
826: select 'Y'
827: from pay_user_columns puc, pay_user_tables put
828: where puc.user_table_id = put.user_table_id
829: and upper(put.user_table_name)= upper(p_eei_information3)
830: and upper(puc.user_column_name) = upper(p_eei_information17);
831:

Line 834: from PAY_USER_ROWS_F pur, pay_user_tables put, fnd_sessions ses

830: and upper(puc.user_column_name) = upper(p_eei_information17);
831:
832: CURSOR c_get_row_name is
833: select 'Y'
834: from PAY_USER_ROWS_F pur, pay_user_tables put, fnd_sessions ses
835: where ses.session_id = userenv('SESSIONID')
836: and pur.user_table_id = put.user_table_id
837: and upper(put.user_table_name)= upper(p_eei_information3)
838: and upper(pur.ROW_LOW_RANGE_OR_NAME) = upper(p_eei_information19)