DBA Data[Home] [Help]

APPS.ZX_SRVC_TYP_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 7804: per_all_assignments_f per

7800: BEGIN
7801: SELECT per.organization_id
7802: INTO ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.poo_party_id(p_trx_line_index)
7803: FROM ra_salesreps_all sales,
7804: per_all_assignments_f per
7805: WHERE sales.salesrep_id = l_source_id
7806: AND per.person_id = sales.person_id
7807: AND nvl(per.primary_flag,'Y') = 'Y'
7808: AND l_trx_date BETWEEN nvl(per.effective_start_date,l_trx_date)

Line 7821: per_all_assignments_f per

7817: BEGIN
7818: SELECT per.organization_id
7819: INTO ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.poo_party_id(p_trx_line_index)
7820: FROM jtf_rs_srp_vl sales,
7821: per_all_assignments_f per
7822: WHERE sales.resource_id = l_source_id
7823: AND per.person_id = sales.person_id
7824: AND nvl(per.primary_flag,'Y') = 'Y'
7825: AND l_trx_date BETWEEN nvl(per.effective_start_date,l_trx_date)