[Home] [Help]
92: G_CONC_LOGIN_ID,
93: G_APPL_ID,
94: G_REQUEST_ID
95: from hz_organization_profiles hzop,
96: jtf_tty_named_accts na
97: where hzop.party_id = na.party_id
98: and sysdate between hzop.effective_start_date and nvl(hzop.effective_END_date, sysdate)
99: and na.party_id = partyList(i)
100: );
146: G_APPL_ID,
147: G_REQUEST_ID
148: from hz_financial_numbers hfn,
149: hz_financial_reports hfr,
150: jtf_tty_named_accts na
151: where hfn.financial_report_id = hfr.financial_report_id
152: and hfr.type_of_financial_report = 'INCOME_STATEMENT'
153: and hfn.financial_number_name = 'SALES'
154: and hfr.party_id = na.party_id
238: from ( select na.named_account_id,
239: nvl(sum(l.total_amount),0) prior_sales
240: from as_leads_all l,
241: as_statuses_b s,
242: jtf_tty_named_accts na
243: where l.status = s.status_code
244: and s.win_loss_indicator = 'W'
245: and l.decision_date between l_calc_start_date and l_calc_end_date
246: and l.customer_id = na.party_id
269:
270: CURSOR c_get_parties
271: IS
272: SELECT party_id
273: FROM jtf_tty_named_accts;
274:
275: partyList PARTY_LIST_TABLE;
276: numRows NATURAL := 10000;
277:
320: /* The following statement fetches numRows (or less). */
321: FETCH c_get_parties BULK COLLECT INTO partyList LIMIT numRows;
322:
323:
324: print_log(' Started Processing ' || partyList.count || ' rows from JTF_TTY_NAMED_ACCTS' );
325: IF (p_metric_code = 'ALL') OR ( p_metric_code = 'DNB_NUM_EMPLOYEES' )
326: THEN
327: print_log(' Calculating DNB EMployees ');
328: l_proc_name := 'CALCULATE_DNB_EMPLOYEES';
344: calculate_prior_sales(partyList);
345: END IF;
346:
347:
348: print_log(' Completed Processing ' || partyList.count || ' rows from JTF_TTY_NAMED_ACCTS' );
349: EXIT WHEN c_get_parties%NOTFOUND;
350:
351: i := i + 1;
352: numRowsProcessed := numRows * i;