DBA Data[Home] [Help]

APPS.PAY_GB_PAYROLL_ACTIONS_PKG dependencies on PAY_USER_TABLES

Line 898: pay_user_tables put,

894: CURSOR c_find_row_values IS
895: SELECT puci.value intval
896: FROM pay_user_rows pur,
897: pay_user_columns puc,
898: pay_user_tables put,
899: pay_user_column_instances puci
900: WHERE put.user_table_name = g_user_table_name
901: AND put.business_group_id is NULL
902: AND put.legislation_code = 'GB'

Line 1921: pay_user_tables put,

1917: SELECT pur.row_low_range_or_name row_name,
1918: puci.value user_desc
1919: FROM pay_user_rows pur,
1920: pay_user_columns puc,
1921: pay_user_tables put,
1922: pay_user_column_instances puci
1923: WHERE put.user_table_name = g_user_table_name
1924: AND put.legislation_code = 'GB'
1925: AND puc.user_column_name = 'Narrative'

Line 2355: pay_user_tables put,

2351: SELECT pur.row_low_range_or_name row_name,
2352: puci.value user_desc
2353: FROM pay_user_rows pur,
2354: pay_user_columns puc,
2355: pay_user_tables put,
2356: pay_user_column_instances puci
2357: WHERE put.user_table_name = g_user_table_name
2358: AND put.legislation_code = 'GB'
2359: AND puc.user_column_name = 'Narrative'

Line 3063: from pay_user_tables put

3059: --
3060:
3061: cursor c_find_table_id is
3062: select put.user_table_id
3063: from pay_user_tables put
3064: where put.user_table_name = g_user_table_name
3065: and put.business_group_id is NULL
3066: and put.legislation_code = 'GB';
3067:

Line 3143: from pay_user_tables put

3139: p_dimension_name in varchar2) is
3140:
3141: cursor c_find_table_id is
3142: select put.user_table_id
3143: from pay_user_tables put
3144: where put.user_table_name = g_user_table_name
3145: and put.business_group_id is NULL
3146: and put.legislation_code = 'GB';
3147: