APPS.PAY_IE_PYMT_SUMMARY_RPT_PKG dependencies on PAY_PAYROLLS_F

Line 91: l_payroll_name pay_payrolls_f.payroll_name%TYPE;

87: p_xml OUT NOCOPY CLOB
88: )
89: IS
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);

Line 100: FROM pay_payrolls_f

96:
97: CURSOR csr_payroll_name
98: IS
99: SELECT DISTINCT payroll_name
100: FROM pay_payrolls_f
101: WHERE payroll_id = p_payroll_id;
102:
103: --
104: CURSOR csr_time_period