APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PQP_EXTRACT_ATTRIBUTES

Line 70: l_extract_attributes pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes%ROWTYPE;

66: ,p_trace_on IN VARCHAR2
67: )
68: IS
69:
70: l_extract_attributes pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes%ROWTYPE;
71: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
72:
73: BEGIN
74:

Line 80: OPEN pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;

76:
77: -- Set the trace flag, but only the first time around
78: IF g_trace IS NULL THEN
79:
80: OPEN pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;
81: FETCH pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes INTO l_extract_attributes;
82: CLOSE pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;
83:
84: l_business_group_id := fnd_global.per_business_group_id;

Line 81: FETCH pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes INTO l_extract_attributes;

77: -- Set the trace flag, but only the first time around
78: IF g_trace IS NULL THEN
79:
80: OPEN pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;
81: FETCH pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes INTO l_extract_attributes;
82: CLOSE pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;
83:
84: l_business_group_id := fnd_global.per_business_group_id;
85:

Line 82: CLOSE pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;

78: IF g_trace IS NULL THEN
79:
80: OPEN pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;
81: FETCH pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes INTO l_extract_attributes;
82: CLOSE pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;
83:
84: l_business_group_id := fnd_global.per_business_group_id;
85:
86: BEGIN

Line 4671: FROM pqp_extract_attributes pqea

4667:
4668: -- Cursor declaration
4669: CURSOR csr_person_reported IS
4670: SELECT 'Y'
4671: FROM pqp_extract_attributes pqea
4672: ,ben_ext_rslt rslt
4673: ,ben_ext_rslt_dtl rdtl
4674: ,ben_ext_rcd drcd
4675: WHERE pqea.ext_dfn_type = g_extract_type