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 45: p_person_id IN per_people_f.person_id%TYPE,

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

Line 86: FROM per_people_f ppf, per_addresses pad

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