APPS.PER_ZA_WSP_ARCHIVE_PKG dependencies on PAY_USER_COLUMNS

Line 181: , pay_user_columns puc

177: --
178: cursor g_csr_le is
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

Line 182: , pay_user_columns puc1

178: cursor g_csr_le is
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

Line 459: , pay_user_columns_tl puc

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

Line 3099: , pay_user_columns puc

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
3102: and puc.user_column_name like p_legal_entity_id || '%'
3103: and put.user_table_id = pur.user_table_id

Line 3647: , pay_user_columns puc

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
3650: and puc.user_column_name like to_char(p_legal_entity_id) || '%'
3651: and put.user_table_id = pur.user_table_id

Line 3944: l_user_column_id_flex pay_user_columns.user_column_id%type;

3940: p_business_group_id in per_all_assignments_f.business_group_id%type
3941: ) is
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;

Line 3945: l_user_column_id_seg pay_user_columns.user_column_id%type;

3941: ) is
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);

Line 3962: from pay_user_columns

3958: and legislation_code = 'ZA';
3959:
3960: select user_column_id
3961: into l_user_column_id_flex
3962: from pay_user_columns
3963: where user_table_id = l_user_table_id
3964: and business_group_id is null
3965: and legislation_code = 'ZA'
3966: and user_column_name = 'Flexfield';

Line 3970: from pay_user_columns

3966: and user_column_name = 'Flexfield';
3967:
3968: select user_column_id
3969: into l_user_column_id_seg
3970: from pay_user_columns
3971: where user_table_id = l_user_table_id
3972: and business_group_id is null
3973: and legislation_code = 'ZA'
3974: and user_column_name = 'Segment';