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_WSP_ARCHIVE_PKG dependencies on PAY_USER_ROWS_F

Line 183: , pay_user_rows_f pur

179: select distinct to_number(substr(puc1.user_column_name,1, instr(puc1.user_column_name,'_')-1)) organization_id
180: from pay_user_tables put
181: , pay_user_columns puc
182: , pay_user_columns puc1
183: , pay_user_rows_f pur
184: , pay_user_column_instances_f puci
185: where put.user_table_name = g_priority_udt_name
186: and puc.user_table_id = put.user_table_id
187: and pur.user_table_id = put.user_table_id

Line 452: from pay_user_rows_f

448: ) is
449:
450: cursor csr_get_pri_name(p_csr_user_row_id number) is
451: select row_low_range_or_name --, effective_start_date, effective_end_date
452: from pay_user_rows_f
453: where user_row_id = p_csr_user_row_id
454: and p_effective_date between effective_start_date and effective_end_date;
455:
456: cursor csr_get_legal_entity (p_csr_user_row_id number) is

Line 3097: , pay_user_rows_f pur

3093: -- Get the Valid Priorities defined for a specific Legal Entity
3094: cursor csr_get_all_pri_le is
3095: select puci.user_row_id
3096: from pay_user_tables put
3097: , pay_user_rows_f pur
3098: , pay_user_column_instances_f puci
3099: , pay_user_columns puc
3100: where put.user_table_name = 'ZA_WSP_SKILLS_PRIORITIES'
3101: and put.user_table_id = puc.user_table_id

Line 3645: , pay_user_rows_f pur

3641: -- Get the Valid Priorities defined for a specific Legal Entity
3642: cursor csr_get_all_pri_le is
3643: select puci.user_row_id
3644: from pay_user_tables put
3645: , pay_user_rows_f pur
3646: , pay_user_column_instances_f puci
3647: , pay_user_columns puc
3648: where put.user_table_name = 'ZA_WSP_SKILLS_PRIORITIES'
3649: and put.user_table_id = puc.user_table_id

Line 3946: l_user_row_id_cat pay_user_rows_f.user_row_id%type;

3942:
3943: l_user_table_id pay_user_tables.user_table_id%type;
3944: l_user_column_id_flex pay_user_columns.user_column_id%type;
3945: l_user_column_id_seg pay_user_columns.user_column_id%type;
3946: l_user_row_id_cat pay_user_rows_f.user_row_id%type;
3947: l_user_row_id_lev pay_user_rows_f.user_row_id%type;
3948: l_user_row_id_func pay_user_rows_f.user_row_id%type;
3949: l_temp varchar2(9);
3950:

Line 3947: l_user_row_id_lev pay_user_rows_f.user_row_id%type;

3943: l_user_table_id pay_user_tables.user_table_id%type;
3944: l_user_column_id_flex pay_user_columns.user_column_id%type;
3945: l_user_column_id_seg pay_user_columns.user_column_id%type;
3946: l_user_row_id_cat pay_user_rows_f.user_row_id%type;
3947: l_user_row_id_lev pay_user_rows_f.user_row_id%type;
3948: l_user_row_id_func pay_user_rows_f.user_row_id%type;
3949: l_temp varchar2(9);
3950:
3951: begin

Line 3948: l_user_row_id_func pay_user_rows_f.user_row_id%type;

3944: l_user_column_id_flex pay_user_columns.user_column_id%type;
3945: l_user_column_id_seg pay_user_columns.user_column_id%type;
3946: l_user_row_id_cat pay_user_rows_f.user_row_id%type;
3947: l_user_row_id_lev pay_user_rows_f.user_row_id%type;
3948: l_user_row_id_func pay_user_rows_f.user_row_id%type;
3949: l_temp varchar2(9);
3950:
3951: begin
3952:

Line 3978: from pay_user_rows_f

3974: and user_column_name = 'Segment';
3975:
3976: select user_row_id
3977: into l_user_row_id_cat
3978: from pay_user_rows_f
3979: where user_table_id = l_user_table_id
3980: and row_low_range_or_name = 'Occupational Categories'
3981: and p_report_date between effective_start_date and effective_end_date;
3982:

Line 3985: from pay_user_rows_f

3981: and p_report_date between effective_start_date and effective_end_date;
3982:
3983: select user_row_id
3984: into l_user_row_id_lev
3985: from pay_user_rows_f
3986: where user_table_id = l_user_table_id
3987: and row_low_range_or_name = 'Occupational Levels'
3988: and p_report_date between effective_start_date and effective_end_date;
3989:

Line 3992: from pay_user_rows_f

3988: and p_report_date between effective_start_date and effective_end_date;
3989:
3990: select user_row_id
3991: into l_user_row_id_func
3992: from pay_user_rows_f
3993: where user_table_id = l_user_table_id
3994: and row_low_range_or_name = 'Function Type'
3995: and p_report_date between effective_start_date and effective_end_date;
3996: