APPS.PAY_GB_P11D_ARCHIVE_SS dependencies on PAY_USER_TABLES

Line 359: l_table_id pay_user_tables.user_table_id%TYPE;

355:
356: PROCEDURE archinit(p_payroll_action_id IN NUMBER)
357: IS
358: l_proc CONSTANT VARCHAR2(50) := g_package || ' archinit';
359: l_table_id pay_user_tables.user_table_id%TYPE;
360:
361: FUNCTION fetch_validation_table_id(p_table_name VARCHAR2)
362: RETURN NUMBER
363: IS

Line 364: l_table_id pay_user_tables.user_table_id%TYPE;

360:
361: FUNCTION fetch_validation_table_id(p_table_name VARCHAR2)
362: RETURN NUMBER
363: IS
364: l_table_id pay_user_tables.user_table_id%TYPE;
365: BEGIN
366: SELECT user_table_id
367: INTO l_table_id
368: FROM pay_user_tables

Line 368: FROM pay_user_tables

364: l_table_id pay_user_tables.user_table_id%TYPE;
365: BEGIN
366: SELECT user_table_id
367: INTO l_table_id
368: FROM pay_user_tables
369: WHERE UPPER(user_table_name) = UPPER(p_table_name) AND business_group_id IS NULL AND legislation_code = 'GB';
370:
371: RETURN l_table_id;
372: END;

Line 385: pay_user_tables tab,

381: ff.effective_start_date ff_start_date, ff.effective_end_date ff_end_date
382: FROM pay_user_column_instances_f cinst,
383: pay_user_columns c,
384: pay_user_rows_f r,
385: pay_user_tables tab,
386: ff_formulas_f ff
387: WHERE tab.user_table_id = p_table_id AND c.user_table_id = tab.user_table_id
388: AND NVL(c.business_group_id, p_bus_group_id) = p_bus_group_id AND NVL(c.legislation_code, 'GB') =
389: 'GB'