APPS.PER_ZA_EMPLOYMENT_EQUITY_PKG dependencies on PAY_USER_COLUMNS

Line 458: pay_user_columns puccat,

454: select pucifcat.value
455: into l_termination_reason
456: from pay_user_column_instances_f pucifcat,
457: pay_user_rows_f purfcat,
458: pay_user_columns puccat,
459: pay_user_rows_f purfqc,
460: pay_user_column_instances_f pucifqc,
461: pay_user_columns pucqc,
462: pay_user_tables put

Line 461: pay_user_columns pucqc,

457: pay_user_rows_f purfcat,
458: pay_user_columns puccat,
459: pay_user_rows_f purfqc,
460: pay_user_column_instances_f pucifqc,
461: pay_user_columns pucqc,
462: pay_user_tables put
463: where put.user_table_name = 'ZA_TERMINATION_CATEGORIES'
464: and put.business_group_id is null
465: and put.legislation_code = 'ZA'

Line 1578: l_user_column_id_flex pay_user_columns.user_column_id%type;

1574: p_business_group_id in per_all_assignments_f.business_group_id%type
1575: ) is
1576:
1577: l_user_table_id pay_user_tables.user_table_id%type;
1578: l_user_column_id_flex pay_user_columns.user_column_id%type;
1579: l_user_column_id_seg pay_user_columns.user_column_id%type;
1580: l_user_row_id_cat pay_user_rows_f.user_row_id%type;
1581: l_user_row_id_lev pay_user_rows_f.user_row_id%type;
1582: l_user_row_id_func pay_user_rows_f.user_row_id%type;

Line 1579: l_user_column_id_seg pay_user_columns.user_column_id%type;

1575: ) is
1576:
1577: l_user_table_id pay_user_tables.user_table_id%type;
1578: l_user_column_id_flex pay_user_columns.user_column_id%type;
1579: l_user_column_id_seg pay_user_columns.user_column_id%type;
1580: l_user_row_id_cat pay_user_rows_f.user_row_id%type;
1581: l_user_row_id_lev pay_user_rows_f.user_row_id%type;
1582: l_user_row_id_func pay_user_rows_f.user_row_id%type;
1583: l_temp varchar2(9);

Line 1599: from pay_user_columns

1595: hr_utility.set_location('l_user_table_id'||l_user_table_id, 10);
1596:
1597: select user_column_id
1598: into l_user_column_id_flex
1599: from pay_user_columns
1600: where user_table_id = l_user_table_id
1601: and business_group_id is null
1602: and legislation_code = 'ZA'
1603: and user_column_name = 'Flexfield';

Line 1607: from pay_user_columns

1603: and user_column_name = 'Flexfield';
1604:
1605: select user_column_id
1606: into l_user_column_id_seg
1607: from pay_user_columns
1608: where user_table_id = l_user_table_id
1609: and business_group_id is null
1610: and legislation_code = 'ZA'
1611: and user_column_name = 'Segment';