APPS.PAY_IE_PYMT_SUMMARY_RPT_PKG dependencies on PAY_CONSOLIDATION_SETS

Line 94: pay_consolidation_sets.consolidation_set_name%TYPE;

90: l_time_period per_time_periods.period_name%TYPE;
91: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
92: l_bg_name VARCHAR2 (240);
93: l_consolidation_set_name
94: pay_consolidation_sets.consolidation_set_name%TYPE;
95: l_report_date VARCHAR2 (12);
96:
97: CURSOR csr_payroll_name
98: IS

Line 114: FROM pay_consolidation_sets

110: --
111: CURSOR csr_consolidation_set_name
112: IS
113: SELECT consolidation_set_name
114: FROM pay_consolidation_sets
115: WHERE consolidation_set_id = p_consolidation_set_id;
116:
117: --
118: CURSOR csr_get_pymt_data