APPS.PAY_NO_PAYPROC dependencies on PER_ADDRESSES

Line 113: FROM per_addresses pad

109: AND ppt.payment_type_id= opm.payment_type_id
110: AND ( ppt.payment_type_name like 'NO Money Order' or ppt.category in ('MT'))
111: AND pap.person_id = NVL(p_person_id,pap.person_id)
112: AND (ppt.category in ('MT') or exists ( select '1'
113: FROM per_addresses pad
114: WHERE pad.person_id = asg.person_id
115: and pad.PRIMARY_FLAG ='Y')
116: )
117: AND (p_assignment_set_id IS NULL

Line 579: l_address1 per_addresses.ADDRESS_LINE1%TYPE;

575:
576: l_payee_name varchar2(100);
577:
578:
579: l_address1 per_addresses.ADDRESS_LINE1%TYPE;
580: l_address2 per_addresses.ADDRESS_LINE2%TYPE;
581: l_post_code per_addresses.POSTAL_CODE%TYPE;
582: --Modified for bug fix 4253729
583: l_city VARCHAR2(80); --per_addresses.TOWN_OR_CITY%TYPE;

Line 580: l_address2 per_addresses.ADDRESS_LINE2%TYPE;

576: l_payee_name varchar2(100);
577:
578:
579: l_address1 per_addresses.ADDRESS_LINE1%TYPE;
580: l_address2 per_addresses.ADDRESS_LINE2%TYPE;
581: l_post_code per_addresses.POSTAL_CODE%TYPE;
582: --Modified for bug fix 4253729
583: l_city VARCHAR2(80); --per_addresses.TOWN_OR_CITY%TYPE;
584:

Line 581: l_post_code per_addresses.POSTAL_CODE%TYPE;

577:
578:
579: l_address1 per_addresses.ADDRESS_LINE1%TYPE;
580: l_address2 per_addresses.ADDRESS_LINE2%TYPE;
581: l_post_code per_addresses.POSTAL_CODE%TYPE;
582: --Modified for bug fix 4253729
583: l_city VARCHAR2(80); --per_addresses.TOWN_OR_CITY%TYPE;
584:
585: --Modified cursor for bug fix 4253729

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

579: l_address1 per_addresses.ADDRESS_LINE1%TYPE;
580: l_address2 per_addresses.ADDRESS_LINE2%TYPE;
581: l_post_code per_addresses.POSTAL_CODE%TYPE;
582: --Modified for bug fix 4253729
583: l_city VARCHAR2(80); --per_addresses.TOWN_OR_CITY%TYPE;
584:
585: --Modified cursor for bug fix 4253729
586: CURSOR csr_get_address(p_assignment_id number)
587: is

Line 589: FROM per_addresses pad

585: --Modified cursor for bug fix 4253729
586: CURSOR csr_get_address(p_assignment_id number)
587: is
588: select ADDRESS_LINE1,ADDRESS_LINE2,POSTAL_CODE --,TOWN_OR_CITY
589: FROM per_addresses pad
590: ,per_all_assignments_f paf
591: ,per_all_people_f pef
592:
593: WHERE paf.assignment_id=p_assignment_id