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 204: g_lev_flex pay_user_column_instances_f.value%type := null;

200: g_cat_name hr_lookups.meaning%type;
201: g_cat_report_date date;
202: g_cat_asg_id per_all_assignments_f.assignment_id%type;
203:
204: g_lev_flex pay_user_column_instances_f.value%type := null;
205: g_lev_segment pay_user_column_instances_f.value%type := null;
206: g_cat_flex pay_user_column_instances_f.value%type := null;
207: g_cat_segment pay_user_column_instances_f.value%type := null;
208: g_f_type_name hr_lookups.meaning%type;

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

201: g_cat_report_date date;
202: g_cat_asg_id per_all_assignments_f.assignment_id%type;
203:
204: g_lev_flex pay_user_column_instances_f.value%type := null;
205: g_lev_segment pay_user_column_instances_f.value%type := null;
206: g_cat_flex pay_user_column_instances_f.value%type := null;
207: g_cat_segment pay_user_column_instances_f.value%type := null;
208: g_f_type_name hr_lookups.meaning%type;
209: g_Func_flex pay_user_column_instances_f.value%type := null;

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

202: g_cat_asg_id per_all_assignments_f.assignment_id%type;
203:
204: g_lev_flex pay_user_column_instances_f.value%type := null;
205: g_lev_segment pay_user_column_instances_f.value%type := null;
206: g_cat_flex pay_user_column_instances_f.value%type := null;
207: g_cat_segment pay_user_column_instances_f.value%type := null;
208: g_f_type_name hr_lookups.meaning%type;
209: g_Func_flex pay_user_column_instances_f.value%type := null;
210: g_Func_segment pay_user_column_instances_f.value%type := null;

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

203:
204: g_lev_flex pay_user_column_instances_f.value%type := null;
205: g_lev_segment pay_user_column_instances_f.value%type := null;
206: g_cat_flex pay_user_column_instances_f.value%type := null;
207: g_cat_segment pay_user_column_instances_f.value%type := null;
208: g_f_type_name hr_lookups.meaning%type;
209: g_Func_flex pay_user_column_instances_f.value%type := null;
210: g_Func_segment pay_user_column_instances_f.value%type := null;
211:

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

205: g_lev_segment pay_user_column_instances_f.value%type := null;
206: g_cat_flex pay_user_column_instances_f.value%type := null;
207: g_cat_segment pay_user_column_instances_f.value%type := null;
208: g_f_type_name hr_lookups.meaning%type;
209: g_Func_flex pay_user_column_instances_f.value%type := null;
210: g_Func_segment pay_user_column_instances_f.value%type := null;
211:
212: g_high1 number := 0;
213: g_high2 number := 0;

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

206: g_cat_flex pay_user_column_instances_f.value%type := null;
207: g_cat_segment pay_user_column_instances_f.value%type := null;
208: g_f_type_name hr_lookups.meaning%type;
209: g_Func_flex pay_user_column_instances_f.value%type := null;
210: g_Func_segment pay_user_column_instances_f.value%type := null;
211:
212: g_high1 number := 0;
213: g_high2 number := 0;
214: g_high3 number := 0;

Line 497: l_termination_reason pay_user_column_instances_f.value%type;

493: p_report_date in per_all_assignments_f.effective_end_date%type,
494: p_reason_code in per_periods_of_service.leaving_reason%type
495: ) return varchar2 is
496:
497: l_termination_reason pay_user_column_instances_f.value%type;
498:
499: begin
500:
501: select pucifcat.value

Line 503: from pay_user_column_instances_f pucifcat,

499: begin
500:
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,

Line 507: pay_user_column_instances_f pucifqc,

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

Line 1673: from pay_user_column_instances_f

1669: and p_report_date between effective_start_date and effective_end_date;
1670:
1671: select value
1672: into g_cat_flex
1673: from pay_user_column_instances_f
1674: where user_row_id = l_user_row_id_cat
1675: and user_column_id = l_user_column_id_flex
1676: and business_group_id = p_business_group_id
1677: and p_report_date between effective_start_date and effective_end_date;

Line 1681: from pay_user_column_instances_f

1677: and p_report_date between effective_start_date and effective_end_date;
1678:
1679: select value
1680: into g_cat_segment
1681: from pay_user_column_instances_f
1682: where user_row_id = l_user_row_id_cat
1683: and user_column_id = l_user_column_id_seg
1684: and business_group_id = p_business_group_id
1685: and p_report_date between effective_start_date and effective_end_date;

Line 1710: from pay_user_column_instances_f

1706:
1707:
1708: select value
1709: into g_lev_flex
1710: from pay_user_column_instances_f
1711: where user_row_id = l_user_row_id_lev
1712: and user_column_id = l_user_column_id_flex
1713: and business_group_id = p_business_group_id
1714: and p_report_date between effective_start_date and effective_end_date;

Line 1718: from pay_user_column_instances_f

1714: and p_report_date between effective_start_date and effective_end_date;
1715:
1716: select value
1717: into g_Func_flex
1718: from pay_user_column_instances_f
1719: where user_row_id = l_user_row_id_func
1720: and user_column_id = l_user_column_id_flex
1721: and business_group_id = p_business_group_id
1722: and p_report_date between effective_start_date and effective_end_date;

Line 1726: from pay_user_column_instances_f

1722: and p_report_date between effective_start_date and effective_end_date;
1723:
1724: select value
1725: into g_lev_segment
1726: from pay_user_column_instances_f
1727: where user_row_id = l_user_row_id_lev
1728: and user_column_id = l_user_column_id_seg
1729: and business_group_id = p_business_group_id
1730: and p_report_date between effective_start_date and effective_end_date;

Line 1735: from pay_user_column_instances_f

1731:
1732:
1733: select value
1734: into g_Func_segment
1735: from pay_user_column_instances_f
1736: where user_row_id = l_user_row_id_func
1737: and user_column_id = l_user_column_id_seg
1738: and business_group_id = p_business_group_id
1739: and p_report_date between effective_start_date and effective_end_date;

Line 7326: l_termination_reason pay_user_column_instances_f.value%type;

7322: p_report_date in per_all_assignments_f.effective_end_date%type,
7323: p_reason_code in per_periods_of_service.leaving_reason%type
7324: ) return varchar2 is
7325:
7326: l_termination_reason pay_user_column_instances_f.value%type;
7327:
7328: begin
7329:
7330: select pucifcat.value

Line 7332: from pay_user_column_instances_f pucifcat,

7328: begin
7329:
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,

Line 7336: pay_user_column_instances_f pucifqc,

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