DBA Data[Home] [Help]

APPS.PAY_NL_TAXOFFICE_ARCHIVE dependencies on PAY_USER_TABLES

Line 3294: pay_user_tables put

3290:
3291: CURSOR csr_get_rows IS
3292: select pur.user_row_id
3293: from pay_user_rows_f pur,
3294: pay_user_tables put
3295: where put.user_table_name='NL_ATS_USER_BALANCES'
3296: and put.legislation_code='NL'
3297: and pur.user_table_id=put.user_table_id
3298: and p_effective_date between pur.effective_start_date and pur.effective_end_date;

Line 3319: pay_user_tables put

3315:
3316: SELECT puc.user_column_id
3317: INTO vBalColId
3318: FROM pay_user_columns puc,
3319: pay_user_tables put
3320: WHERE put.user_table_name='NL_ATS_USER_BALANCES'
3321: and put.legislation_code='NL'
3322: and put.user_table_id=puc.user_table_id
3323: and puc.user_column_name='BAL_NAME';

Line 3340: pay_user_tables put

3336:
3337: SELECT puc.user_column_id
3338: INTO vTagColId
3339: FROM pay_user_columns puc,
3340: pay_user_tables put
3341: WHERE put.user_table_name='NL_ATS_USER_BALANCES'
3342: and put.legislation_code='NL'
3343: and put.user_table_id=puc.user_table_id
3344: and puc.user_column_name='TAG_NAME';