APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on PQP_EXTRACT_ATTRIBUTES

Line 50: CURSOR csr_pqp_extract_attributes(p_ext_dfn_id IN NUMBER DEFAULT NULL) IS

46:
47: --
48: --
49: --
50: CURSOR csr_pqp_extract_attributes(p_ext_dfn_id IN NUMBER DEFAULT NULL) IS
51: SELECT eat.ext_dfn_type
52: ,udt.user_table_name
53: ,udt.user_table_id
54: FROM pqp_extract_attributes eat

Line 54: FROM pqp_extract_attributes eat

50: CURSOR csr_pqp_extract_attributes(p_ext_dfn_id IN NUMBER DEFAULT NULL) IS
51: SELECT eat.ext_dfn_type
52: ,udt.user_table_name
53: ,udt.user_table_id
54: FROM pqp_extract_attributes eat
55: ,pay_user_tables udt
56: WHERE eat.ext_dfn_id = nvl(p_ext_dfn_id, ben_ext_thread.g_ext_dfn_id)
57: AND udt.user_table_id(+) = eat.ext_user_table_id;
58: --

Line 555: ,pqp_extract_attributes pqea

551: SELECT MIN(to_date(rdtl.VAL_13, 'DDMMYY')) prev_start_date
552: FROM ben_ext_rslt rslt
553: ,ben_ext_rslt_dtl rdtl
554: ,ben_ext_rcd drcd
555: ,pqp_extract_attributes pqea
556: WHERE pqea.ext_dfn_type = g_extract_type
557: AND rslt.ext_dfn_id = pqea.ext_dfn_id
558: AND rslt.business_group_id = nvl(p_business_group_id,g_business_group_id) --BG ID
559: AND rslt.ext_stat_cd NOT IN