APPS.BEN_ON_LINE_LF_EVT dependencies on PER_ASSIGNMENTS_F

Line 2462: from per_assignments_f paf

2458: l_rule_rec c_rule%rowtype;
2459: --
2460: cursor per_asn is
2461: select assignment_id,organization_id
2462: from per_assignments_f paf
2463: where paf.person_id = p_person_id
2464: and paf.assignment_type <> 'C'
2465: and paf.primary_flag = 'Y'
2466: and paf.business_group_id + 0= p_business_group_id

Line 2518: -- Get assignment ID,organization_id form per_assignments_f table.

2514: p_message_count := null;
2515: --
2516: if p_person_id is not null then
2517: --
2518: -- Get assignment ID,organization_id form per_assignments_f table.
2519: --
2520: open per_asn;
2521: fetch per_asn into l_asn;
2522: if per_asn%notfound then