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 927: -- INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N1)

923: -- RUN_RESULT_ID,
924: -- RESULT_VALUE)
925: -- select /*+ ORDERED
926: -- USE_NL(PRR PPA PIV)
927: -- INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N1)
928: -- INDEX(PRR PAY_RUN_RESULTS_N50)
929: -- INDEX(PPA PAY_PAYROLL_ACTIONS_PK)
930: -- INDEX(PIV PAY_INPUT_VALUES_F_N50) */
931: -- piv.input_value_id,

Line 934: -- from pay_assignment_actions paa,

930: -- INDEX(PIV PAY_INPUT_VALUES_F_N50) */
931: -- piv.input_value_id,
932: -- prr.run_result_id,
933: -- null
934: -- from pay_assignment_actions paa,
935: -- pay_run_results prr,
936: -- pay_payroll_actions ppa,
937: -- pay_input_values_f piv
938: -- where paa.assignment_id = p_assignment_id

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

960: insert into pay_run_result_values(
961: INPUT_VALUE_ID,
962: RUN_RESULT_ID,
963: RESULT_VALUE)
964: select /*+ INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51)
965: INDEX(PRR PAY_RUN_RESULTS_N50)
966: INDEX(PPA PAY_PAYROLL_ACTIONS_PK)
967: INDEX(PIV PAY_INPUT_VALUES_F_N50) */
968: piv.input_value_id,

Line 971: from pay_assignment_actions paa,

967: INDEX(PIV PAY_INPUT_VALUES_F_N50) */
968: piv.input_value_id,
969: prr.run_result_id,
970: null
971: from pay_assignment_actions paa,
972: pay_run_results prr,
973: pay_payroll_actions ppa,
974: pay_input_values_f piv
975: where paa.assignment_id = p_assignment_id

Line 1228: pay_assignment_actions paa

1224: --
1225: cursor csr_exists is
1226: select 'TRUE'
1227: from pay_jp_pre_tax_old ppt,
1228: pay_assignment_actions paa
1229: where paa.action_status = 'C'
1230: and ppt.assignment_action_id = paa.assignment_action_id
1231: and ppt.assignment_action_id NOT IN (
1232: select action_information1

Line 1263: pay_assignment_actions paa

1259: --
1260: cursor csr_ppt is
1261: select 'Y'
1262: from pay_jp_pre_tax_old ppt,
1263: pay_assignment_actions paa
1264: where paa.assignment_id = p_assignment_id
1265: and paa.action_status = 'C'
1266: and ppt.assignment_action_id = paa.assignment_action_id
1267: and ppt.assignment_action_id NOT IN (

Line 1309: pay_assignment_actions paa,

1305: --
1306: cursor csr_pre_tax is
1307: select ppt.*, ppa.effective_date
1308: from pay_jp_pre_tax_old ppt,
1309: pay_assignment_actions paa,
1310: pay_payroll_actions ppa
1311: where paa.assignment_id = p_assignment_id
1312: and paa.assignment_action_id = ppt.assignment_action_id
1313: and paa.payroll_action_id = ppa.payroll_action_id

Line 1799: from pay_assignment_actions paa,

1795: select 'Y'
1796: from dual
1797: where exists(
1798: select null
1799: from pay_assignment_actions paa,
1800: pay_payroll_actions ppa
1801: where paa.assignment_id = p_assignment_id
1802: and paa.action_status = 'C'
1803: and ppa.payroll_action_id = paa.payroll_action_id

Line 1878: from pay_assignment_actions paa,

1874: other2.ACTION_INFORMATION19 WTM_SYSTEM_DESC_KANJI_1,
1875: other2.ACTION_INFORMATION20 WTM_SYSTEM_DESC_KANJI_2,
1876: other2.ACTION_INFORMATION21 WTM_SYSTEM_DESC_KANA_1,
1877: other2.ACTION_INFORMATION22 WTM_SYSTEM_DESC_KANA_2
1878: from pay_assignment_actions paa,
1879: pay_payroll_actions ppa,
1880: pay_action_information person,
1881: pay_action_information arch,
1882: pay_action_information other2