APPS.PAY_NO_PAYPROC dependencies on PER_ADDRESSES

Line 106: FROM per_addresses pad

102: AND ppt.payment_type_id= opm.payment_type_id
103: AND ( ppt.payment_type_name like 'NO Money Order' or ppt.category in ('MT'))
104: AND pap.person_id = NVL(p_person_id,pap.person_id)
105: AND (ppt.category in ('MT') or exists ( select '1'
106: FROM per_addresses pad
107: WHERE pad.person_id = asg.person_id
108: and pad.PRIMARY_FLAG ='Y')
109: )
110: AND (p_assignment_set_id IS NULL

Line 556: l_address1 per_addresses.ADDRESS_LINE1%TYPE;

552:
553: l_payee_name varchar2(100);
554:
555:
556: l_address1 per_addresses.ADDRESS_LINE1%TYPE;
557: l_address2 per_addresses.ADDRESS_LINE2%TYPE;
558: l_post_code per_addresses.POSTAL_CODE%TYPE;
559: --Modified for bug fix 4253729
560: l_city VARCHAR2(80); --per_addresses.TOWN_OR_CITY%TYPE;

Line 557: l_address2 per_addresses.ADDRESS_LINE2%TYPE;

553: l_payee_name varchar2(100);
554:
555:
556: l_address1 per_addresses.ADDRESS_LINE1%TYPE;
557: l_address2 per_addresses.ADDRESS_LINE2%TYPE;
558: l_post_code per_addresses.POSTAL_CODE%TYPE;
559: --Modified for bug fix 4253729
560: l_city VARCHAR2(80); --per_addresses.TOWN_OR_CITY%TYPE;
561:

Line 558: l_post_code per_addresses.POSTAL_CODE%TYPE;

554:
555:
556: l_address1 per_addresses.ADDRESS_LINE1%TYPE;
557: l_address2 per_addresses.ADDRESS_LINE2%TYPE;
558: l_post_code per_addresses.POSTAL_CODE%TYPE;
559: --Modified for bug fix 4253729
560: l_city VARCHAR2(80); --per_addresses.TOWN_OR_CITY%TYPE;
561:
562: --Modified cursor for bug fix 4253729

Line 560: l_city VARCHAR2(80); --per_addresses.TOWN_OR_CITY%TYPE;

556: l_address1 per_addresses.ADDRESS_LINE1%TYPE;
557: l_address2 per_addresses.ADDRESS_LINE2%TYPE;
558: l_post_code per_addresses.POSTAL_CODE%TYPE;
559: --Modified for bug fix 4253729
560: l_city VARCHAR2(80); --per_addresses.TOWN_OR_CITY%TYPE;
561:
562: --Modified cursor for bug fix 4253729
563: CURSOR csr_get_address(p_assignment_id number)
564: is

Line 566: FROM per_addresses pad

562: --Modified cursor for bug fix 4253729
563: CURSOR csr_get_address(p_assignment_id number)
564: is
565: select ADDRESS_LINE1,ADDRESS_LINE2,POSTAL_CODE --,TOWN_OR_CITY
566: FROM per_addresses pad
567: ,per_all_assignments_f paf
568: ,per_all_people_f pef
569:
570: WHERE paf.assignment_id=p_assignment_id