DBA Data[Home] [Help]

APPS.PER_MX_DATA_PUMP dependencies on PAY_USER_COLUMNS

Line 94: FROM pay_user_columns puc,

90:
91: FUNCTION GET_WORK_SCHEDULE (p_work_schedule varchar2) RETURN number IS
92: CURSOR csr_get_work_schedule IS
93: SELECT puc.user_column_id
94: FROM pay_user_columns puc,
95: pay_user_tables put
96: WHERE puc.user_table_id = put.user_table_id
97: AND puc.legislation_code = put.legislation_code
98: AND puc.user_column_name = p_work_schedule

Line 103: l_user_column_id pay_user_columns.user_column_id%type;

99: AND put.user_table_name = 'COMPANY WORK SCHEDULES'
100: AND put.legislation_code = 'MX'
101: AND puc.business_group_id IS NULL;
102:
103: l_user_column_id pay_user_columns.user_column_id%type;
104: l_proc_name varchar2(100);
105: BEGIN
106: l_proc_name := g_proc_name || 'GET_WORK_SCHEDULE';
107: hr_utility.trace('Entering '||l_proc_name);