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_EMP_DT_TAX_VAL dependencies on PER_ADDRESSES

Line 77: per_addresses pa,

73: SELECT pus1.state_code,
74: pus.state_code
75: FROM pay_us_states pus,
76: pay_us_states pus1,
77: per_addresses pa,
78: per_assignments_f paf
79: WHERE paf.assignment_id = p_assignment_id
80: AND p_session_date BETWEEN paf.effective_start_date
81: AND paf.effective_end_date

Line 99: per_addresses pa,

95: FROM pay_us_states pus,
96: pay_us_states pus1,
97: pay_us_counties puc,
98: pay_us_counties puc1,
99: per_addresses pa,
100: per_assignments_f paf
101: WHERE paf.assignment_id = p_assignment_id
102: AND p_session_date BETWEEN paf.effective_start_date
103: AND paf.effective_end_date

Line 130: per_addresses pa,

126: pay_us_counties puc,
127: pay_us_counties puc1,
128: pay_us_city_names pucy,
129: pay_us_city_names pucy1,
130: per_addresses pa,
131: per_assignments_f paf
132: WHERE paf.assignment_id = p_assignment_id
133: AND p_session_date BETWEEN paf.effective_start_date
134: AND paf.effective_end_date

Line 1041: from PER_ADDRESSES pa,

1037: /* modified cursors to check _both_ mailing and taxation address, instead of one or the other */
1038:
1039: CURSOR csr_check_state is
1040: select 1
1041: from PER_ADDRESSES pa,
1042: PER_ASSIGNMENTS_F paf
1043: where paf.assignment_id = p_assignment_id
1044: and pa.person_id = paf.person_id
1045: and exists (select null

Line 1055: from PER_ADDRESSES pa,

1051: resident address of the assignment. */
1052:
1053: CURSOR csr_check_county is
1054: select 1
1055: from PER_ADDRESSES pa,
1056: PER_ASSIGNMENTS_F paf
1057: where paf.assignment_id = p_assignment_id
1058: and pa.person_id = paf.person_id
1059: and exists (select null

Line 1076: from PER_ADDRESSES pa,

1072: resident address of the assignment. */
1073:
1074: CURSOR csr_check_city is
1075: select 1
1076: from PER_ADDRESSES pa,
1077: PER_ASSIGNMENTS_F paf
1078: where paf.assignment_id = p_assignment_id
1079: and pa.person_id = paf.person_id
1080: and exists (select null

Line 1632: PER_ADDRESSES pa,

1628: puci.city_name
1629: from PAY_US_CITY_NAMES puci,
1630: PAY_US_COUNTIES puc,
1631: PAY_US_STATES pus,
1632: PER_ADDRESSES pa,
1633: PER_ASSIGNMENTS_F paf
1634: where paf.assignment_id = p_assignment_id
1635: and p_session_date between paf.effective_start_date and
1636: paf.effective_end_date

Line 2281: PER_ADDRESSES pa,

2277: puci.city_name
2278: from PAY_US_CITY_NAMES puci,
2279: PAY_US_COUNTIES puc,
2280: PAY_US_STATES pus,
2281: PER_ADDRESSES pa,
2282: PER_ASSIGNMENTS_F paf
2283: where paf.assignment_id = p_assignment_id
2284: and p_session_date between paf.effective_start_date and
2285: paf.effective_end_date