3:
4: PROCEDURE Get_Pay_Activity_History
5: ( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
6: pay_act_sql out NOCOPY VARCHAR2,
7: pay_act_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)IS
8: /* declaration section */
9: sqlstmt VARCHAR2(14000);
10:
11: l_as_of_date DATE;
171:
172: PROCEDURE Get_Paid_Inv_Detail
173: ( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
174: paid_inv_sql out NOCOPY VARCHAR2,
175: paid_inv_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)IS
176: /* declaration section */
177: sqlstmt VARCHAR2(14000);
178: sqlstmt1 VARCHAR2(14000);
179:
1128:
1129: PROCEDURE Get_Payment_Detail
1130: ( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
1131: pay_detail_sql out NOCOPY VARCHAR2,
1132: pay_detail_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)IS
1133: /* declaration section */
1134: sqlstmt VARCHAR2(14000);
1135:
1136: l_as_of_date DATE;