APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PQP_EXTRACT_ATTRIBUTES

Line 71: l_extract_attributes pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes%ROWTYPE;

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

Line 81: OPEN pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;

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

Line 82: FETCH pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes INTO l_extract_attributes;

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

Line 83: CLOSE pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;

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

Line 4643: FROM pqp_extract_attributes pqea

4639:
4640: -- Cursor declaration
4641: CURSOR csr_person_reported IS
4642: SELECT 'Y'
4643: FROM pqp_extract_attributes pqea
4644: ,ben_ext_rslt rslt
4645: ,ben_ext_rslt_dtl rdtl
4646: ,ben_ext_rcd drcd
4647: WHERE pqea.ext_dfn_type = g_extract_type