APPS.QP_COUPON_PVT dependencies on QP_NPREQ_LDETS_TMP

Line 775: INDX,QP_COUPON_PVT.Process_Coupon_Issue.get_coupon_issue_lines,qp_npreq_ldets_tmp_U1,LINE_DETAIL_INDEX,1

771: ) IS
772:
773: -- Get coupon issue line
774: /*
775: INDX,QP_COUPON_PVT.Process_Coupon_Issue.get_coupon_issue_lines,qp_npreq_ldets_tmp_U1,LINE_DETAIL_INDEX,1
776:
777: INDX,QP_COUPON_PVT.Process_Coupon_Issue.get_coupon_issue_lines,QP_LIST_LINES_PK,LIST_LINE_ID,1
778: */
779: CURSOR get_coupon_issue_lines IS

Line 808: qp_npreq_ldets_tmp b ,

804: b.process_code,
805: b.applied_flag,
806: b.modifier_level_code
807: FROM qp_npreq_lines_tmp a ,
808: qp_npreq_ldets_tmp b ,
809: QP_LIST_LINES c
810: WHERE a.LINE_INDEX = b.LINE_INDEX
811: AND b.LINE_DETAIL_INDEX = p_line_detail_index
812: AND b.CREATED_FROM_LIST_LINE_ID = c.LIST_LINE_ID

Line 917: INDX,QP_COUPON_PVT.Process_Coupon_Issue.Process_Coupon_Issue_upd1,qp_npreq_ldets_tmp_U1,LINE_DETAIL_INDEX,1

913: IF (J = 1) THEN
914:
915: --DBMS_OUTPUT.PUT_LINE('Update Coupon No'||l_coupon_number);
916: /*
917: INDX,QP_COUPON_PVT.Process_Coupon_Issue.Process_Coupon_Issue_upd1,qp_npreq_ldets_tmp_U1,LINE_DETAIL_INDEX,1
918: */
919: UPDATE qp_npreq_ldets_tmp
920: SET PROCESSED_FLAG = 'Y',
921: LIST_LINE_NO = l_coupon_number,

Line 919: UPDATE qp_npreq_ldets_tmp

915: --DBMS_OUTPUT.PUT_LINE('Update Coupon No'||l_coupon_number);
916: /*
917: INDX,QP_COUPON_PVT.Process_Coupon_Issue.Process_Coupon_Issue_upd1,qp_npreq_ldets_tmp_U1,LINE_DETAIL_INDEX,1
918: */
919: UPDATE qp_npreq_ldets_tmp
920: SET PROCESSED_FLAG = 'Y',
921: LIST_LINE_NO = l_coupon_number,
922: PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW,
923: PRICING_STATUS_TEXT = 'Coupon_Issue'

Line 931: --FROM qp_npreq_ldets_tmp;

927: ELSE
928:
929: --SELECT max(line_detail_index)
930: --INTO l_line_detail_index
931: --FROM qp_npreq_ldets_tmp;
932:
933: l_line_detail_index := QP_PREQ_GRP.GET_LINE_DETAIL_INDEX;
934:
935: --DBMS_OUTPUT.PUT_LINE('max line detail'||l_line_detail_index);

Line 938: INSERT INTO qp_npreq_ldets_tmp(

934:
935: --DBMS_OUTPUT.PUT_LINE('max line detail'||l_line_detail_index);
936: -- 3. create adjustment line
937:
938: INSERT INTO qp_npreq_ldets_tmp(
939: LINE_DETAIL_INDEX,
940: LINE_DETAIL_TYPE_CODE,
941: LINE_INDEX,
942: CREATED_FROM_LIST_HEADER_ID,

Line 1018: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_ldets_tmp_N7,PRICING_STATUS_CODE,1

1014: )
1015: IS
1016:
1017: /*
1018: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_ldets_tmp_N7,PRICING_STATUS_CODE,1
1019:
1020: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_line_attrs_tmp_N7,LINE_INDEX,1
1021: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_line_attrs_tmp_N7,ATTRIBUTE_TYPE,2
1022: INDX,QP_COUPON_PVT.Redeem_Coupons.get_coupons,qp_npreq_line_attrs_tmp_N7,CONTEXT,3

Line 1032: qp_npreq_ldets_tmp qpd,

1028: CURSOR get_coupons_ldet IS
1029: SELECT /*+ ordered index(qplat) index( qpl) index( qpd)*/ DISTINCT qpc.coupon_number, --5658579
1030: qpl.pricing_effective_date
1031: FROM qp_npreq_line_attrs_tmp qplat,
1032: qp_npreq_ldets_tmp qpd,
1033: qp_npreq_lines_tmp qpl,
1034: qp_coupons qpc
1035: WHERE qplat.line_index = qpd.line_index
1036: and qpl.line_index = qpd.line_index

Line 1052: qp_npreq_ldets_tmp qpd,

1048: CURSOR get_coupons_line IS
1049: SELECT DISTINCT coupon_number,
1050: qpl.pricing_effective_date
1051: FROM qp_npreq_line_attrs_tmp qplat,
1052: qp_npreq_ldets_tmp qpd,
1053: qp_npreq_lines_tmp qpl,
1054: qp_qualifiers qpq,
1055: qp_coupons qpc
1056: WHERE qplat.line_index = qpl.line_index