APPS.CN_REASONS_PUB dependencies on CN_PAYMENT_WORKSHEETS

Line 68: cn_payment_worksheets w,

64: p.name,p.payrun_id,p.pay_period_id,p.status,
65: ps.period_name,s.salesrep_id,s.resource_id,s.name,
66: s.employee_number,pg.pay_group_id,pg.name
67: FROM cn_payruns p,
68: cn_payment_worksheets w,
69: cn_salesreps s,
70: cn_period_statuses ps,
71: cn_pay_groups pg
72: WHERE p.payrun_id = w.payrun_id

Line 419: CURSOR get_notes_count(p_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,

415: x_loading_status OUT NOCOPY VARCHAR2,
416: x_notes_tbl OUT NOCOPY cn_reasons_pub.notes_tbl,
417: x_notes_count OUT NOCOPY NUMBER)
418: IS
419: CURSOR get_notes_count(p_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,
420: p_lookup_type cn_reasons.lookup_type%TYPE,
421: p_table_name cn_reasons.updated_table%TYPE)
422: IS
423: SELECT COUNT(1) cnt

Line 429: CURSOR get_notes_info(p_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,

425: WHERE r.upd_table_id = p_payment_worksheet_id
426: AND r.lookup_type = p_lookup_type
427: AND r.updated_table = p_table_name;
428:
429: CURSOR get_notes_info(p_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,
430: p_lookup_type cn_reasons.lookup_type%TYPE,
431: p_table_name cn_reasons.updated_table%TYPE)
432: IS
433: SELECT v.*