DBA Data[Home] [Help]

APPS.PQP_GB_TP_EXT_PROCESS dependencies on PER_BUSINESS_GROUPS_PERF

Line 1662: FROM per_business_groups_perf

1658: AND nvl(lei.information_type,'PQP_GB_EDU_ESTB_INFO') = 'PQP_GB_EDU_ESTB_INFO';
1659:
1660: CURSOR csr_bg_name(p_business_group_id IN NUMBER) IS
1661: SELECT name
1662: FROM per_business_groups_perf
1663: WHERE business_group_id = p_business_group_id;
1664:
1665: PROGRAM_FAILURE CONSTANT NUMBER := 2 ;
1666: PROGRAM_SUCCESS CONSTANT NUMBER := 0 ;

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

1685: l_multiproc_data pqp_gb_t1_pension_extracts.csr_multiproc_data%ROWTYPE;
1686: l_lea_dets_by_loc pqp_gb_tp_pension_extracts.csr_lea_details_by_loc%ROWTYPE;
1687:
1688: l_ext_udt_id pay_user_tables.user_table_id%TYPE;
1689: l_bg_name per_business_groups_perf.name%TYPE := NULL;
1690:
1691: l_proc_name VARCHAR2 (80) := g_proc_name
1692: || 'tpa_extract_process';
1693: