APPS.PER_ZA_WSP_ARCHIVE_PKG dependencies on PAY_USER_COLUMN_INSTANCES_F

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

41: g_legal_entity_id number(30);
42: g_archive_effective_date date;
43: g_pactid number;
44:
45: g_cat_flex pay_user_column_instances_f.value%type := null;
46: g_cat_segment pay_user_column_instances_f.value%type := null;
47:
48: g_plan_year number(10);
49:

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

42: g_archive_effective_date date;
43: g_pactid number;
44:
45: g_cat_flex pay_user_column_instances_f.value%type := null;
46: g_cat_segment pay_user_column_instances_f.value%type := null;
47:
48: g_plan_year number(10);
49:
50: g_wsp_start_date date;

Line 184: , pay_user_column_instances_f puci

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
188: and pur.business_group_id = g_bg_id

Line 458: from pay_user_column_instances_f puci

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
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;

Line 3098: , pay_user_column_instances_f puci

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
3102: and puc.user_column_name like p_legal_entity_id || '%'

Line 3646: , pay_user_column_instances_f puci

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

Line 4000: from pay_user_column_instances_f

3996:
3997:
3998: select value
3999: into g_cat_flex
4000: from pay_user_column_instances_f
4001: where user_row_id = l_user_row_id_cat
4002: and user_column_id = l_user_column_id_flex
4003: and business_group_id = p_business_group_id
4004: and p_report_date between effective_start_date and effective_end_date;

Line 4008: from pay_user_column_instances_f

4004: and p_report_date between effective_start_date and effective_end_date;
4005:
4006: select value
4007: into g_cat_segment
4008: from pay_user_column_instances_f
4009: where user_row_id = l_user_row_id_cat
4010: and user_column_id = l_user_column_id_seg
4011: and business_group_id = p_business_group_id
4012: and p_report_date between effective_start_date and effective_end_date;