APPS.CN_PREPOST_PVT dependencies on CN_WORKSHEET_BONUSES

Line 754: FROM cn_worksheet_bonuses wsb

750: CURSOR get_ws_manual_exp ( v_payment_worksheet_id IN NUMBER ) IS
751: SELECT wsb.quota_id ,
752: wsb.srp_plan_assign_id ,
753: wsb.amount
754: FROM cn_worksheet_bonuses wsb
755: WHERE wsb.payment_worksheet_id = v_payment_worksheet_id;
756:
757: -- Cursor used to pick up payruns and update their posting statuses STATUS to
758: -- POSTED if all the corresponding payment worksheets are posted successfully

Line 825: -- (e.g., Manual incentive type from CN_WORKSHEET_BONUSES

821: -- 5. BONUS To Recover (will recover from comm if possible)
822: -- MANUAL Incentive Type
823: -- 6. MANUAL Expense e.g., Earned and should not be categorized as
824: -- "NRec" in the worksheet
825: -- (e.g., Manual incentive type from CN_WORKSHEET_BONUSES
826: -- thru a join from CN_WORKSHEETS)
827: -- Identify each posting trx type from the many buckets in the worksheet
828: -- and loop thru build posting details to match and committing a
829: -- worksheet at a time.

Line 937: -- (e.g., Manual incentive type from CN_WORKSHEET_BONUSES

933: END IF;
934:
935: -- 6. MANUAL Expense e.g., Earned and should not be categorized as
936: -- "NRec" in the worksheet
937: -- (e.g., Manual incentive type from CN_WORKSHEET_BONUSES
938: -- thru a join from CN_WORKSHEETS)
939:
940: FOR l_manual_exp_rec IN get_ws_manual_exp(l_pay_ws_rec.payment_worksheet_id) LOOP
941: IF l_manual_exp_rec.AMOUNT <> 0 THEN