eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ZA_EMPLOYMENT_EQUITY_PKG dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 157: g_lev_flex pay_user_column_instances_f.value%type := null;

153: g_cat_name hr_lookups.meaning%type;
154: g_cat_report_date date;
155: g_cat_asg_id per_all_assignments_f.assignment_id%type;
156:
157: g_lev_flex pay_user_column_instances_f.value%type := null;
158: g_lev_segment pay_user_column_instances_f.value%type := null;
159: g_cat_flex pay_user_column_instances_f.value%type := null;
160: g_cat_segment pay_user_column_instances_f.value%type := null;
161: g_f_type_name hr_lookups.meaning%type;

Line 158: g_lev_segment pay_user_column_instances_f.value%type := null;

154: g_cat_report_date date;
155: g_cat_asg_id per_all_assignments_f.assignment_id%type;
156:
157: g_lev_flex pay_user_column_instances_f.value%type := null;
158: g_lev_segment pay_user_column_instances_f.value%type := null;
159: g_cat_flex pay_user_column_instances_f.value%type := null;
160: g_cat_segment pay_user_column_instances_f.value%type := null;
161: g_f_type_name hr_lookups.meaning%type;
162: g_Func_flex pay_user_column_instances_f.value%type := null;

Line 159: g_cat_flex pay_user_column_instances_f.value%type := null;

155: g_cat_asg_id per_all_assignments_f.assignment_id%type;
156:
157: g_lev_flex pay_user_column_instances_f.value%type := null;
158: g_lev_segment pay_user_column_instances_f.value%type := null;
159: g_cat_flex pay_user_column_instances_f.value%type := null;
160: g_cat_segment pay_user_column_instances_f.value%type := null;
161: g_f_type_name hr_lookups.meaning%type;
162: g_Func_flex pay_user_column_instances_f.value%type := null;
163: g_Func_segment pay_user_column_instances_f.value%type := null;

Line 160: g_cat_segment pay_user_column_instances_f.value%type := null;

156:
157: g_lev_flex pay_user_column_instances_f.value%type := null;
158: g_lev_segment pay_user_column_instances_f.value%type := null;
159: g_cat_flex pay_user_column_instances_f.value%type := null;
160: g_cat_segment pay_user_column_instances_f.value%type := null;
161: g_f_type_name hr_lookups.meaning%type;
162: g_Func_flex pay_user_column_instances_f.value%type := null;
163: g_Func_segment pay_user_column_instances_f.value%type := null;
164:

Line 162: g_Func_flex pay_user_column_instances_f.value%type := null;

158: g_lev_segment pay_user_column_instances_f.value%type := null;
159: g_cat_flex pay_user_column_instances_f.value%type := null;
160: g_cat_segment pay_user_column_instances_f.value%type := null;
161: g_f_type_name hr_lookups.meaning%type;
162: g_Func_flex pay_user_column_instances_f.value%type := null;
163: g_Func_segment pay_user_column_instances_f.value%type := null;
164:
165: g_high1 number := 0;
166: g_high2 number := 0;

Line 163: g_Func_segment pay_user_column_instances_f.value%type := null;

159: g_cat_flex pay_user_column_instances_f.value%type := null;
160: g_cat_segment pay_user_column_instances_f.value%type := null;
161: g_f_type_name hr_lookups.meaning%type;
162: g_Func_flex pay_user_column_instances_f.value%type := null;
163: g_Func_segment pay_user_column_instances_f.value%type := null;
164:
165: g_high1 number := 0;
166: g_high2 number := 0;
167: g_high3 number := 0;

Line 450: l_termination_reason pay_user_column_instances_f.value%type;

446: p_report_date in per_all_assignments_f.effective_end_date%type,
447: p_reason_code in per_periods_of_service.leaving_reason%type
448: ) return varchar2 is
449:
450: l_termination_reason pay_user_column_instances_f.value%type;
451:
452: begin
453:
454: select pucifcat.value

Line 456: from pay_user_column_instances_f pucifcat,

452: begin
453:
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,

Line 460: pay_user_column_instances_f pucifqc,

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
463: where put.user_table_name = 'ZA_TERMINATION_CATEGORIES'
464: and put.business_group_id is null

Line 1637: from pay_user_column_instances_f

1633:
1634:
1635: select value
1636: into g_cat_flex
1637: from pay_user_column_instances_f
1638: where user_row_id = l_user_row_id_cat
1639: and user_column_id = l_user_column_id_flex
1640: and business_group_id = p_business_group_id
1641: and p_report_date between effective_start_date and effective_end_date;

Line 1645: from pay_user_column_instances_f

1641: and p_report_date between effective_start_date and effective_end_date;
1642:
1643: select value
1644: into g_lev_flex
1645: from pay_user_column_instances_f
1646: where user_row_id = l_user_row_id_lev
1647: and user_column_id = l_user_column_id_flex
1648: and business_group_id = p_business_group_id
1649: and p_report_date between effective_start_date and effective_end_date;

Line 1653: from pay_user_column_instances_f

1649: and p_report_date between effective_start_date and effective_end_date;
1650:
1651: select value
1652: into g_Func_flex
1653: from pay_user_column_instances_f
1654: where user_row_id = l_user_row_id_func
1655: and user_column_id = l_user_column_id_flex
1656: and business_group_id = p_business_group_id
1657: and p_report_date between effective_start_date and effective_end_date;

Line 1661: from pay_user_column_instances_f

1657: and p_report_date between effective_start_date and effective_end_date;
1658:
1659: select value
1660: into g_lev_segment
1661: from pay_user_column_instances_f
1662: where user_row_id = l_user_row_id_lev
1663: and user_column_id = l_user_column_id_seg
1664: and business_group_id = p_business_group_id
1665: and p_report_date between effective_start_date and effective_end_date;

Line 1669: from pay_user_column_instances_f

1665: and p_report_date between effective_start_date and effective_end_date;
1666:
1667: select value
1668: into g_cat_segment
1669: from pay_user_column_instances_f
1670: where user_row_id = l_user_row_id_cat
1671: and user_column_id = l_user_column_id_seg
1672: and business_group_id = p_business_group_id
1673: and p_report_date between effective_start_date and effective_end_date;

Line 1677: from pay_user_column_instances_f

1673: and p_report_date between effective_start_date and effective_end_date;
1674:
1675: select value
1676: into g_Func_segment
1677: from pay_user_column_instances_f
1678: where user_row_id = l_user_row_id_func
1679: and user_column_id = l_user_column_id_seg
1680: and business_group_id = p_business_group_id
1681: and p_report_date between effective_start_date and effective_end_date;