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

Line 103: ,pay_assignment_actions pac

99: ,pay_element_types_f et
100: ,pay_input_values_f iv1
101: ,pay_element_entries_F ee
102: ,pay_element_entry_values_F eev1
103: ,pay_assignment_actions pac
104: ,pay_payroll_actions ppa
105: WHERE per.person_id = asg1.person_id
106: AND ppa.BUSINESS_GROUP_ID = per.BUSINESS_GROUP_ID
107: and ppa.effective_date BETWEEN per.effective_start_date and per.effective_end_date

Line 138: FROM pay_payroll_actions ppa, pay_assignment_actions paa

134:
135:
136: CURSOR c_effective_date(p_asg_act_id NUMBER ) IS
137: SELECT effective_date
138: FROM pay_payroll_actions ppa, pay_assignment_actions paa
139: WHERE paa.assignment_action_id = p_asg_act_id
140: AND paa.payroll_action_id = ppa.payroll_action_id ;
141:
142:

Line 217: FROM pay_assignment_actions paa_xfr,

213: AND application_column_name = UPPER (p_node);
214:
215: CURSOR csr_get_chk_no IS
216: SELECT paa_chk.serial_number
217: FROM pay_assignment_actions paa_xfr,
218: pay_action_interlocks pai_xfr,
219: pay_action_interlocks pai_chk,
220: pay_assignment_actions paa_chk,
221: pay_payroll_actions ppa_chk

Line 220: pay_assignment_actions paa_chk,

216: SELECT paa_chk.serial_number
217: FROM pay_assignment_actions paa_xfr,
218: pay_action_interlocks pai_xfr,
219: pay_action_interlocks pai_chk,
220: pay_assignment_actions paa_chk,
221: pay_payroll_actions ppa_chk
222: WHERE paa_xfr.assignment_action_id = pai_xfr.locking_action_id
223: AND pai_xfr.locked_action_id = pai_chk.locked_action_id
224: AND pai_chk.locking_action_id = paa_chk.assignment_action_id

Line 230: l_chk_no pay_assignment_actions.serial_number%type;

226: AND ppa_chk.action_type = 'H'
227: AND paa_xfr.assignment_action_id = g_action_ctx_id;
228:
229: l_tag_name varchar2(500);
230: l_chk_no pay_assignment_actions.serial_number%type;
231: l_data pay_action_information.action_information1%type;
232:
233: PROCEDURE LOAD_XML_INTERNAL (
234: P_NODE_TYPE varchar2,

Line 324: FROM pay_assignment_actions paa

320: AND pai.action_context_id=p_action_context_id;
321:
322: /*AND (pai.action_context_id = p_action_context_id
323: OR pai.action_context_id = ( SELECT paa.source_action_id
324: FROM pay_assignment_actions paa
325: WHERE paa.assignment_action_id = p_action_context_id
326: AND paa.assignment_id = pai.Assignment_ID
327: )); */
328:

Line 347: ,pay_assignment_actions paa

343: ,substr(pai1.action_information9,instr(pai1.action_information9,':',-1)+1) unit_price
344: ,pai1.action_information4 value
345: FROM pay_action_information pai
346: ,pay_action_information pai1
347: ,pay_assignment_actions paa
348: WHERE pai.action_context_type = 'PA'
349: AND pai.action_information_category = p_pa_category
350: AND pai1.action_context_type = 'AAP'
351: AND pai.action_information5 <> 'F'

Line 355: FROM pay_assignment_actions paa

351: AND pai.action_information5 <> 'F'
352: AND pai1.action_information3 <> 'F'
353: -- Commented for performance fix
354: /* AND ( pai1.action_context_id in ( SELECT paa.assignment_action_id
355: FROM pay_assignment_actions paa
356: WHERE paa.source_action_id = p_action_context_id
357: AND paa.assignment_id = pai1.assignment_id
358: )
359: OR pai1.action_context_id = p_action_context_id) */

Line 390: ,pay_assignment_actions paa

386: --,sum(pai1.action_information4) value
387: ,pai1.action_information4 value
388: FROM pay_action_information pai
389: ,pay_action_information pai1
390: ,pay_assignment_actions paa
391: WHERE pai.action_context_type = 'PA'
392: AND pai.action_information_category = p_pa_category
393: AND pai1.action_context_type = 'AAP'
394: AND pai.action_information5 <> 'F'

Line 397: FROM pay_assignment_actions paa

393: AND pai1.action_context_type = 'AAP'
394: AND pai.action_information5 <> 'F'
395: AND pai1.action_information3 <> 'F'
396: AND ( pai1.action_context_id in ( SELECT paa.assignment_action_id
397: FROM pay_assignment_actions paa
398: WHERE paa.source_action_id = p_action_context_id
399: AND paa.assignment_id = pai1.assignment_id
400: )
401: OR pai1.action_context_id = p_action_context_id)

Line 424: ,pay_assignment_actions paa

420: --,pai1.action_information8 record_count
421: ,sum(pai1.action_information4) value
422: FROM pay_action_information pai
423: ,pay_action_information pai1
424: ,pay_assignment_actions paa
425: WHERE pai.action_context_type = 'PA'
426: AND pai.action_information_category = p_pa_category
427: AND pai1.action_context_type = 'AAP'
428: AND pai.action_information5 <> 'F'

Line 431: FROM pay_assignment_actions paa

427: AND pai1.action_context_type = 'AAP'
428: AND pai.action_information5 <> 'F'
429: AND pai1.action_information3 <> 'F'
430: AND ( pai1.action_context_id in ( SELECT paa.assignment_action_id
431: FROM pay_assignment_actions paa
432: WHERE paa.source_action_id = p_action_context_id
433: AND paa.assignment_id = pai1.assignment_id
434: )
435: OR pai1.action_context_id = p_action_context_id)

Line 468: ,pay_assignment_actions paa

464: ,substr(pai1.action_information9,instr(pai1.action_information9,':',-1)+1) unit_price
465: ,pai1.action_information4 value
466: FROM pay_action_information pai
467: ,pay_action_information pai1
468: ,pay_assignment_actions paa
469: WHERE pai.action_context_type = 'PA'
470: AND pai.action_information_category = p_pa_category
471: AND pai1.action_context_type = 'AAP'
472: AND pai.action_information5 = 'F'

Line 476: FROM pay_assignment_actions paa

472: AND pai.action_information5 = 'F'
473: AND pai1.action_information3 = 'F'
474: -- Commented for performance fix
475: /* AND ( pai1.action_context_id in ( SELECT paa.assignment_action_id
476: FROM pay_assignment_actions paa
477: WHERE paa.source_action_id = p_action_context_id
478: AND paa.assignment_id = pai1.assignment_id
479: )
480: OR pai1.action_context_id = p_action_context_id) */

Line 661: ,pay_assignment_actions pac

657: ,pay_element_types_f et
658: ,pay_input_values_f iv1
659: ,pay_element_entries_F ee
660: ,pay_element_entry_values_F eev1
661: ,pay_assignment_actions pac
662: ,pay_payroll_actions ppa
663: WHERE per.person_id = asg1.person_id
664: AND ppa.BUSINESS_GROUP_ID = per.BUSINESS_GROUP_ID
665: and ppa.effective_date BETWEEN per.effective_start_date and per.effective_end_date