DBA Data[Home] [Help]

APPS.PAY_GB_PAYROLL_ACTIONS_PKG dependencies on PAY_USER_TABLES

Line 881: pay_user_tables put,

877: CURSOR c_find_row_values IS
878: SELECT puci.value intval
879: FROM pay_user_rows pur,
880: pay_user_columns puc,
881: pay_user_tables put,
882: pay_user_column_instances puci
883: WHERE put.user_table_name = g_user_table_name
884: AND put.business_group_id is NULL
885: AND put.legislation_code = 'GB'

Line 1896: pay_user_tables put,

1892: SELECT pur.row_low_range_or_name row_name,
1893: puci.value user_desc
1894: FROM pay_user_rows pur,
1895: pay_user_columns puc,
1896: pay_user_tables put,
1897: pay_user_column_instances puci
1898: WHERE put.user_table_name = g_user_table_name
1899: AND put.legislation_code = 'GB'
1900: AND puc.user_column_name = 'Narrative'

Line 2662: from pay_user_tables put

2658: --
2659:
2660: cursor c_find_table_id is
2661: select put.user_table_id
2662: from pay_user_tables put
2663: where put.user_table_name = g_user_table_name
2664: and put.business_group_id is NULL
2665: and put.legislation_code = 'GB';
2666:

Line 2742: from pay_user_tables put

2738: p_dimension_name in varchar2) is
2739:
2740: cursor c_find_table_id is
2741: select put.user_table_id
2742: from pay_user_tables put
2743: where put.user_table_name = g_user_table_name
2744: and put.business_group_id is NULL
2745: and put.legislation_code = 'GB';
2746: