DBA Data[Home] [Help]

APPS.PQP_GB_TP_EXT_PROCESS dependencies on PER_BUSINESS_GROUPS_PERF

Line 1672: FROM per_business_groups_perf

1668: AND nvl(lei.information_type,'PQP_GB_EDU_ESTB_INFO') = 'PQP_GB_EDU_ESTB_INFO';
1669:
1670: CURSOR csr_bg_name(p_business_group_id IN NUMBER) IS
1671: SELECT name
1672: FROM per_business_groups_perf
1673: WHERE business_group_id = p_business_group_id;
1674:
1675: PROGRAM_FAILURE CONSTANT NUMBER := 2 ;
1676: PROGRAM_SUCCESS CONSTANT NUMBER := 0 ;

Line 1699: l_bg_name per_business_groups_perf.name%TYPE := NULL;

1695: l_multiproc_data pqp_gb_t1_pension_extracts.csr_multiproc_data%ROWTYPE;
1696: l_lea_dets_by_loc pqp_gb_tp_pension_extracts.csr_lea_details_by_loc%ROWTYPE;
1697:
1698: l_ext_udt_id pay_user_tables.user_table_id%TYPE;
1699: l_bg_name per_business_groups_perf.name%TYPE := NULL;
1700:
1701: l_proc_name VARCHAR2 (80) := g_proc_name
1702: || 'tpa_extract_process';
1703: