APPS.PER_ZA_WSP_ARCHIVE_PKG dependencies on PAY_USER_COLUMNS

Line 180: , pay_user_columns puc

176: --
177: cursor g_csr_le is
178: select distinct to_number(substr(puc1.user_column_name,1, instr(puc1.user_column_name,'_')-1)) organization_id
179: from pay_user_tables put
180: , pay_user_columns puc
181: , pay_user_columns puc1
182: , pay_user_rows_f pur
183: , pay_user_column_instances_f puci
184: where put.user_table_name = g_priority_udt_name

Line 181: , pay_user_columns puc1

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

Line 458: , pay_user_columns_tl puc

454:
455: cursor csr_get_legal_entity (p_csr_user_row_id number) is
456: select distinct substr(puc.user_column_name,1, instr(puc.user_column_name,'_')-1) organization_id
457: from pay_user_column_instances_f puci
458: , pay_user_columns_tl puc
459: where puci.user_row_id = p_csr_user_row_id
460: and puc.user_column_id = puci.user_column_id
461: and p_effective_date between puci.effective_start_date and puci.effective_end_date;
462:

Line 3093: , pay_user_columns puc

3089: select puci.user_row_id
3090: from pay_user_tables put
3091: , pay_user_rows_f pur
3092: , pay_user_column_instances_f puci
3093: , pay_user_columns puc
3094: where put.user_table_name = 'ZA_WSP_SKILLS_PRIORITIES'
3095: and put.user_table_id = puc.user_table_id
3096: and puc.user_column_name like p_legal_entity_id || '%'
3097: and put.user_table_id = pur.user_table_id

Line 3641: , pay_user_columns puc

3637: select puci.user_row_id
3638: from pay_user_tables put
3639: , pay_user_rows_f pur
3640: , pay_user_column_instances_f puci
3641: , pay_user_columns puc
3642: where put.user_table_name = 'ZA_WSP_SKILLS_PRIORITIES'
3643: and put.user_table_id = puc.user_table_id
3644: and puc.user_column_name like to_char(p_legal_entity_id) || '%'
3645: and put.user_table_id = pur.user_table_id

Line 3938: l_user_column_id_flex pay_user_columns.user_column_id%type;

3934: p_business_group_id in per_all_assignments_f.business_group_id%type
3935: ) is
3936:
3937: l_user_table_id pay_user_tables.user_table_id%type;
3938: l_user_column_id_flex pay_user_columns.user_column_id%type;
3939: l_user_column_id_seg pay_user_columns.user_column_id%type;
3940: l_user_row_id_cat pay_user_rows_f.user_row_id%type;
3941: l_user_row_id_lev pay_user_rows_f.user_row_id%type;
3942: l_user_row_id_func pay_user_rows_f.user_row_id%type;

Line 3939: l_user_column_id_seg pay_user_columns.user_column_id%type;

3935: ) is
3936:
3937: l_user_table_id pay_user_tables.user_table_id%type;
3938: l_user_column_id_flex pay_user_columns.user_column_id%type;
3939: l_user_column_id_seg pay_user_columns.user_column_id%type;
3940: l_user_row_id_cat pay_user_rows_f.user_row_id%type;
3941: l_user_row_id_lev pay_user_rows_f.user_row_id%type;
3942: l_user_row_id_func pay_user_rows_f.user_row_id%type;
3943: l_temp varchar2(9);

Line 3956: from pay_user_columns

3952: and legislation_code = 'ZA';
3953:
3954: select user_column_id
3955: into l_user_column_id_flex
3956: from pay_user_columns
3957: where user_table_id = l_user_table_id
3958: and business_group_id is null
3959: and legislation_code = 'ZA'
3960: and user_column_name = 'Flexfield';

Line 3964: from pay_user_columns

3960: and user_column_name = 'Flexfield';
3961:
3962: select user_column_id
3963: into l_user_column_id_seg
3964: from pay_user_columns
3965: where user_table_id = l_user_table_id
3966: and business_group_id is null
3967: and legislation_code = 'ZA'
3968: and user_column_name = 'Segment';