APPS.PER_ZA_WSP_ARCHIVE_PKG dependencies on PAY_USER_COLUMN_INSTANCES_F

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

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

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

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

Line 183: , pay_user_column_instances_f puci

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
186: and pur.user_table_id = put.user_table_id
187: and pur.business_group_id = g_bg_id

Line 457: from pay_user_column_instances_f puci

453: and p_effective_date between effective_start_date and effective_end_date;
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;

Line 3092: , pay_user_column_instances_f puci

3088: cursor csr_get_all_pri_le is
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 || '%'

Line 3640: , pay_user_column_instances_f puci

3636: cursor csr_get_all_pri_le is
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) || '%'

Line 3994: from pay_user_column_instances_f

3990:
3991:
3992: select value
3993: into g_cat_flex
3994: from pay_user_column_instances_f
3995: where user_row_id = l_user_row_id_cat
3996: and user_column_id = l_user_column_id_flex
3997: and business_group_id = p_business_group_id
3998: and p_report_date between effective_start_date and effective_end_date;

Line 4002: from pay_user_column_instances_f

3998: and p_report_date between effective_start_date and effective_end_date;
3999:
4000: select value
4001: into g_cat_segment
4002: from pay_user_column_instances_f
4003: where user_row_id = l_user_row_id_cat
4004: and user_column_id = l_user_column_id_seg
4005: and business_group_id = p_business_group_id
4006: and p_report_date between effective_start_date and effective_end_date;