eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_ONLINE_W4_XML_PKG dependencies on PER_PEOPLE_F

Line 49: p_person_id IN per_people_f.person_id%TYPE,

45: Description: Returns the XML extract for Online W4 PDF
46: ***************************************************************************/
47: AS
48: PROCEDURE generate_xml (
49: p_person_id IN per_people_f.person_id%TYPE,
50: p_transaction_step_id IN hr_api_transaction_steps.transaction_step_id%TYPE,
51: p_temp_dir IN VARCHAR2,
52: p_appl_short_name IN VARCHAR2,
53: p_template_code IN VARCHAR2,

Line 90: FROM per_people_f ppf, per_addresses pad

86: pad.address_line1,
87: pad.address_line2,
88: pad.address_line3,
89: pad.town_or_city || ', ' || pad.region_2 || ', ' || pad.postal_code city_town_zip
90: FROM per_people_f ppf, per_addresses pad
91: WHERE ppf.person_id = cp_person_id
92: AND ppf.person_id = pad.person_id
93: AND trunc(sysdate) between ppf.effective_start_date
94: and ppf.effective_end_date