DBA Data[Home] [Help]

APPS.ZX_SRVC_TYP_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 6966: per_all_assignments_f per

6962: BEGIN
6963: SELECT per.organization_id
6964: INTO ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.poo_party_id(p_trx_line_index)
6965: FROM ra_salesreps_all sales,
6966: per_all_assignments_f per
6967: WHERE sales.salesrep_id = l_source_id
6968: AND per.person_id = sales.person_id
6969: AND nvl(per.primary_flag,'Y') = 'Y'
6970: AND l_trx_date BETWEEN nvl(per.effective_start_date,l_trx_date)

Line 6983: per_all_assignments_f per

6979: BEGIN
6980: SELECT per.organization_id
6981: INTO ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.poo_party_id(p_trx_line_index)
6982: FROM jtf_rs_srp_vl sales,
6983: per_all_assignments_f per
6984: WHERE sales.resource_id = l_source_id
6985: AND per.person_id = sales.person_id
6986: AND nvl(per.primary_flag,'Y') = 'Y'
6987: AND l_trx_date BETWEEN nvl(per.effective_start_date,l_trx_date)