APPS.PER_ZA_EMPLOYMENT_EQUITY_PKG dependencies on PAY_USER_COLUMNS

Line 505: pay_user_columns puccat,

501: select pucifcat.value
502: into l_termination_reason
503: from pay_user_column_instances_f pucifcat,
504: pay_user_rows_f purfcat,
505: pay_user_columns puccat,
506: pay_user_rows_f purfqc,
507: pay_user_column_instances_f pucifqc,
508: pay_user_columns pucqc,
509: pay_user_tables put

Line 508: pay_user_columns pucqc,

504: pay_user_rows_f purfcat,
505: pay_user_columns puccat,
506: pay_user_rows_f purfqc,
507: pay_user_column_instances_f pucifqc,
508: pay_user_columns pucqc,
509: pay_user_tables put
510: where put.user_table_name = 'ZA_TERMINATION_CATEGORIES'
511: and put.business_group_id is null
512: and put.legislation_code = 'ZA'

Line 1627: l_user_column_id_flex pay_user_columns.user_column_id%type;

1623: p_year in number
1624: ) is
1625:
1626: l_user_table_id pay_user_tables.user_table_id%type;
1627: l_user_column_id_flex pay_user_columns.user_column_id%type;
1628: l_user_column_id_seg pay_user_columns.user_column_id%type;
1629: l_user_row_id_cat pay_user_rows_f.user_row_id%type;
1630: l_user_row_id_lev pay_user_rows_f.user_row_id%type;
1631: l_user_row_id_func pay_user_rows_f.user_row_id%type;

Line 1628: l_user_column_id_seg pay_user_columns.user_column_id%type;

1624: ) is
1625:
1626: l_user_table_id pay_user_tables.user_table_id%type;
1627: l_user_column_id_flex pay_user_columns.user_column_id%type;
1628: l_user_column_id_seg pay_user_columns.user_column_id%type;
1629: l_user_row_id_cat pay_user_rows_f.user_row_id%type;
1630: l_user_row_id_lev pay_user_rows_f.user_row_id%type;
1631: l_user_row_id_func pay_user_rows_f.user_row_id%type;
1632: l_temp varchar2(9);

Line 1648: from pay_user_columns

1644: hr_utility.set_location('l_user_table_id'||l_user_table_id, 10);
1645:
1646: select user_column_id
1647: into l_user_column_id_flex
1648: from pay_user_columns
1649: where user_table_id = l_user_table_id
1650: and business_group_id is null
1651: and legislation_code = 'ZA'
1652: and user_column_name = 'Flexfield';

Line 1656: from pay_user_columns

1652: and user_column_name = 'Flexfield';
1653:
1654: select user_column_id
1655: into l_user_column_id_seg
1656: from pay_user_columns
1657: where user_table_id = l_user_table_id
1658: and business_group_id is null
1659: and legislation_code = 'ZA'
1660: and user_column_name = 'Segment';

Line 7334: pay_user_columns puccat,

7330: select pucifcat.value
7331: into l_termination_reason
7332: from pay_user_column_instances_f pucifcat,
7333: pay_user_rows_f purfcat,
7334: pay_user_columns puccat,
7335: pay_user_rows_f purfqc,
7336: pay_user_column_instances_f pucifqc,
7337: pay_user_columns pucqc,
7338: pay_user_tables put

Line 7337: pay_user_columns pucqc,

7333: pay_user_rows_f purfcat,
7334: pay_user_columns puccat,
7335: pay_user_rows_f purfqc,
7336: pay_user_column_instances_f pucifqc,
7337: pay_user_columns pucqc,
7338: pay_user_tables put
7339: where put.user_table_name = 'ZA_TERMINATION_CATEGORIES'
7340: and put.business_group_id is null
7341: and put.legislation_code = 'ZA'