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_JP_GENERIC_UPGRADE_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 106: pay_assignment_actions paa

102: from dual
103: where exists(
104: select null
105: from pay_jp_pre_tax ppt,
106: pay_assignment_actions paa
107: where paa.action_status = 'C'
108: and ppt.assignment_action_id = paa.assignment_action_id
109: and ppt.action_status = 'C'); */
110: /*

Line 114: pay_assignment_actions paa

110: /*
111: --Bug 4256063---
112: select 'TRUE'
113: from pay_jp_pre_tax ppt,
114: pay_assignment_actions paa
115: where paa.action_status = 'C'
116: and ppt.assignment_action_id = paa.assignment_action_id
117: and ppt.action_status = 'C'
118: and rownum =1 ;

Line 122: pay_assignment_actions paa

118: and rownum =1 ;
119: */
120: select 'TRUE'
121: from pay_action_information pai,
122: pay_assignment_actions paa
123: where paa.action_status = 'C'
124: and pai.action_information_category = 'JP_PRE_TAX_1'
125: and pai.action_context_type = 'AAP'
126: and pai.action_information1 = paa.assignment_action_id

Line 158: pay_assignment_actions paa

154: from dual
155: where exists(
156: select null
157: from pay_jp_pre_tax ppt,
158: pay_assignment_actions paa
159: where paa.assignment_id = p_assignment_id
160: and paa.action_status = 'C'
161: and ppt.assignment_action_id = paa.assignment_action_id
162: and ppt.action_status = 'C');

Line 166: pay_assignment_actions paa

162: and ppt.action_status = 'C');
163: */
164: select 'Y'
165: from pay_action_information pai,
166: pay_assignment_actions paa
167: where paa.assignment_id = p_assignment_id
168: and paa.action_status = 'C'
169: and pai.action_information_category = 'JP_PRE_TAX_1'
170: and pai.action_context_type = 'AAP'

Line 202: pay_assignment_actions paa

198: select pai.action_information29 disaster_tax_reduction,
199: pai.action_information_id,
200: paa.assignment_action_id
201: from pay_action_information pai,
202: pay_assignment_actions paa
203: where paa.assignment_id = p_assignment_id
204: and paa.action_status = 'C'
205: and pai.action_information_category = 'JP_PRE_TAX_1'
206: and pai.action_context_type = 'AAP'

Line 214: pay_assignment_actions paa

210: select ppt.rowid,
211: paa.assignment_action_id,
212: ppt.disaster_tax_reduction
213: from pay_jp_pre_tax ppt,
214: pay_assignment_actions paa
215: where paa.assignment_id = p_assignment_id
216: and paa.action_status = 'C'
217: and ppt.assignment_action_id = paa.assignment_action_id
218: and ppt.action_status = 'C'

Line 609: INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N50)

605: select /*+ ORDERED
606: NO_MERGE(BG)
607: USE_NL(PPA PAA PRR)
608: INDEX(PPA PAY_PAYROLL_ACTIONS_FK1)
609: INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N50)
610: INDEX(PRR PAY_RUN_RESULTS_N50) */
611: null
612: from per_business_groups_perf bg,
613: pay_payroll_actions ppa,

Line 614: pay_assignment_actions paa,

610: INDEX(PRR PAY_RUN_RESULTS_N50) */
611: null
612: from per_business_groups_perf bg,
613: pay_payroll_actions ppa,
614: pay_assignment_actions paa,
615: pay_run_results prr
616: where bg.legislation_code = p_legislation_code
617: and ppa.business_group_id = bg.business_group_id
618: and paa.payroll_action_id = ppa.payroll_action_id

Line 696: from pay_assignment_actions paa,

692: from pay_element_entries_f pee
693: where pee.assignment_id = p_assignment_id)
694: or exists(
695: select null
696: from pay_assignment_actions paa,
697: pay_run_results prr
698: where paa.assignment_id = p_assignment_id
699: and prr.assignment_action_id = paa.assignment_action_id);
700: begin

Line 747: from pay_assignment_actions paa,

743: select /*+ ORDERED
744: USE_NL(PRR)
745: INDEX(PRR PAY_RUN_RESULTS_N50) */
746: null
747: from pay_assignment_actions paa,
748: pay_run_results prr
749: where paa.assignment_id = p_assignment_id
750: and prr.assignment_action_id = paa.assignment_action_id
751: and prr.element_type_id = p_element_type_id);

Line 933: -- INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N1)

929: -- RUN_RESULT_ID,
930: -- RESULT_VALUE)
931: -- select /*+ ORDERED
932: -- USE_NL(PRR PPA PIV)
933: -- INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N1)
934: -- INDEX(PRR PAY_RUN_RESULTS_N50)
935: -- INDEX(PPA PAY_PAYROLL_ACTIONS_PK)
936: -- INDEX(PIV PAY_INPUT_VALUES_F_N50) */
937: -- piv.input_value_id,

Line 940: -- from pay_assignment_actions paa,

936: -- INDEX(PIV PAY_INPUT_VALUES_F_N50) */
937: -- piv.input_value_id,
938: -- prr.run_result_id,
939: -- null
940: -- from pay_assignment_actions paa,
941: -- pay_run_results prr,
942: -- pay_payroll_actions ppa,
943: -- pay_input_values_f piv
944: -- where paa.assignment_id = p_assignment_id

Line 970: select /*+ INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51)

966: insert into pay_run_result_values(
967: INPUT_VALUE_ID,
968: RUN_RESULT_ID,
969: RESULT_VALUE)
970: select /*+ INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51)
971: INDEX(PRR PAY_RUN_RESULTS_N50)
972: INDEX(PPA PAY_PAYROLL_ACTIONS_PK)
973: INDEX(PIV PAY_INPUT_VALUES_F_N50) */
974: piv.input_value_id,

Line 977: from pay_assignment_actions paa,

973: INDEX(PIV PAY_INPUT_VALUES_F_N50) */
974: piv.input_value_id,
975: prr.run_result_id,
976: null
977: from pay_assignment_actions paa,
978: pay_run_results prr,
979: pay_payroll_actions ppa,
980: pay_input_values_f piv
981: where paa.assignment_id = p_assignment_id

Line 1234: pay_assignment_actions paa

1230: --
1231: cursor csr_exists is
1232: select 'TRUE'
1233: from pay_jp_pre_tax_old ppt,
1234: pay_assignment_actions paa
1235: where paa.action_status = 'C'
1236: and ppt.assignment_action_id = paa.assignment_action_id
1237: and ppt.assignment_action_id NOT IN (
1238: select action_information1

Line 1269: pay_assignment_actions paa

1265: --
1266: cursor csr_ppt is
1267: select 'Y'
1268: from pay_jp_pre_tax_old ppt,
1269: pay_assignment_actions paa
1270: where paa.assignment_id = p_assignment_id
1271: and paa.action_status = 'C'
1272: and ppt.assignment_action_id = paa.assignment_action_id
1273: and ppt.assignment_action_id NOT IN (

Line 1315: pay_assignment_actions paa,

1311: --
1312: cursor csr_pre_tax is
1313: select ppt.*, ppa.effective_date
1314: from pay_jp_pre_tax_old ppt,
1315: pay_assignment_actions paa,
1316: pay_payroll_actions ppa
1317: where paa.assignment_id = p_assignment_id
1318: and paa.assignment_action_id = ppt.assignment_action_id
1319: and paa.payroll_action_id = ppa.payroll_action_id

Line 1805: from pay_assignment_actions paa,

1801: select 'Y'
1802: from dual
1803: where exists(
1804: select null
1805: from pay_assignment_actions paa,
1806: pay_payroll_actions ppa
1807: where paa.assignment_id = p_assignment_id
1808: and paa.action_status = 'C'
1809: and ppa.payroll_action_id = paa.payroll_action_id

Line 1884: from pay_assignment_actions paa,

1880: other2.ACTION_INFORMATION19 WTM_SYSTEM_DESC_KANJI_1,
1881: other2.ACTION_INFORMATION20 WTM_SYSTEM_DESC_KANJI_2,
1882: other2.ACTION_INFORMATION21 WTM_SYSTEM_DESC_KANA_1,
1883: other2.ACTION_INFORMATION22 WTM_SYSTEM_DESC_KANA_2
1884: from pay_assignment_actions paa,
1885: pay_payroll_actions ppa,
1886: pay_action_information person,
1887: pay_action_information arch,
1888: pay_action_information other2