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

Line 98: ,pay_assignment_actions pac

94: ,pay_element_types_f et
95: ,pay_input_values_f iv1
96: ,pay_element_entries_F ee
97: ,pay_element_entry_values_F eev1
98: ,pay_assignment_actions pac
99: ,pay_payroll_actions ppa
100: WHERE per.person_id = asg1.person_id
101: AND ppa.BUSINESS_GROUP_ID = per.BUSINESS_GROUP_ID
102: and ppa.effective_date BETWEEN per.effective_start_date and per.effective_end_date

Line 132: pay_assignment_actions pac,

128:
129: CURSOR get_union_id(p_asg_act_id NUMBER) IS
130: SELECT pap.per_information9
131: FROM
132: pay_assignment_actions pac,
133: per_all_assignments assign,
134: per_all_people pap
135: WHERE pac.assignment_action_id = p_asg_act_id
136: AND assign.assignment_id = pac.assignment_id

Line 147: pay_assignment_actions pac

143: hr_soft_coding_keyflex target,
144: per_all_assignments ASSIGN,
145: fnd_id_flex_structures fstruct,
146: pay_legislation_rules leg,
147: pay_assignment_actions pac
148: WHERE fstruct.id_flex_num = leg.rule_mode
149: AND fstruct.id_flex_code = 'SCL'
150: AND fstruct.application_id = 800
151: AND leg.legislation_code = 'FI'

Line 195: FROM pay_payroll_actions ppa, pay_assignment_actions paa

191:
192:
193: CURSOR c_effective_date(p_asg_act_id NUMBER ) IS
194: SELECT effective_date
195: FROM pay_payroll_actions ppa, pay_assignment_actions paa
196: WHERE paa.assignment_action_id = p_asg_act_id
197: AND paa.payroll_action_id = ppa.payroll_action_id ;
198:
199: CURSOR c_person_pension_num(p_asg_act_id NUMBER , p_effective_date DATE) IS

Line 203: ,pay_assignment_actions pac

199: CURSOR c_person_pension_num(p_asg_act_id NUMBER , p_effective_date DATE) IS
200: SELECT PER_INFORMATION24
201: FROM per_all_assignments_f asg1
202: ,per_all_people_f per
203: ,pay_assignment_actions pac
204: WHERE per.person_id = asg1.person_id
205: AND pac.assignment_action_id = p_asg_act_id
206: AND asg1.assignment_id = pac.assignment_id
207: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date

Line 349: pay_assignment_actions pac

345: hr_soft_coding_keyflex target,
346: per_all_assignments ASSIGN,
347: fnd_id_flex_structures fstruct,
348: pay_legislation_rules leg,
349: pay_assignment_actions pac
350: WHERE fstruct.id_flex_num = leg.rule_mode
351: AND fstruct.id_flex_code = 'SCL'
352: AND fstruct.application_id = 800
353: AND leg.legislation_code = 'FI'

Line 370: ,pay_assignment_actions pac

366: ,pay_element_types_f et
367: ,pay_input_values_f iv1
368: ,pay_element_entries_f ee
369: ,pay_element_entry_values_f eev1
370: ,pay_assignment_actions pac
371: ,pay_payroll_actions ppa
372: WHERE pac.assignment_action_id = P_ASG_ACT_ID
373: AND ppa.payroll_action_id = pac.payroll_action_id
374: AND asg1.assignment_id = pac.assignment_id

Line 433: pay_assignment_actions pac

429: hr_soft_coding_keyflex target,
430: per_all_assignments ASSIGN,
431: fnd_id_flex_structures fstruct,
432: pay_legislation_rules leg,
433: pay_assignment_actions pac
434: WHERE fstruct.id_flex_num = leg.rule_mode
435: AND fstruct.id_flex_code = 'SCL'
436: AND fstruct.application_id = 800
437: AND leg.legislation_code = 'FI'

Line 544: FROM pay_assignment_actions paa_xfr,

540: AND application_column_name = UPPER (p_node);
541:
542: CURSOR csr_get_chk_no IS
543: SELECT paa_chk.serial_number
544: FROM pay_assignment_actions paa_xfr,
545: pay_action_interlocks pai_xfr,
546: pay_action_interlocks pai_chk,
547: pay_assignment_actions paa_chk,
548: pay_payroll_actions ppa_chk

Line 547: pay_assignment_actions paa_chk,

543: SELECT paa_chk.serial_number
544: FROM pay_assignment_actions paa_xfr,
545: pay_action_interlocks pai_xfr,
546: pay_action_interlocks pai_chk,
547: pay_assignment_actions paa_chk,
548: pay_payroll_actions ppa_chk
549: WHERE paa_xfr.assignment_action_id = pai_xfr.locking_action_id
550: AND pai_xfr.locked_action_id = pai_chk.locked_action_id
551: AND pai_chk.locking_action_id = paa_chk.assignment_action_id

Line 557: l_chk_no pay_assignment_actions.serial_number%type;

553: AND ppa_chk.action_type = 'H'
554: AND paa_xfr.assignment_action_id = g_action_ctx_id;
555:
556: l_tag_name varchar2(500);
557: l_chk_no pay_assignment_actions.serial_number%type;
558: l_data pay_action_information.action_information1%type;
559:
560: PROCEDURE LOAD_XML_INTERNAL (
561: P_NODE_TYPE varchar2,

Line 656: ,pay_assignment_actions paa

652: ,pai.effective_date payment_date
653: FROM per_time_periods ptp
654: ,pay_payrolls_f ppf
655: ,pay_action_information pai
656: ,pay_assignment_actions paa
657: WHERE ppf.payroll_id = ptp.payroll_id
658: AND pai.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
659: AND ptp.time_period_id = pai.action_information16
660: AND pai.action_context_type = 'AAP'

Line 686: FROM pay_assignment_actions paa

682: AND pai.action_information_category = p_category1
683: -- AND pai1.action_information_category = p_category2
684: AND (pai.action_context_id = p_action_context_id
685: OR pai.action_context_id = ( SELECT paa.source_action_id
686: FROM pay_assignment_actions paa
687: WHERE paa.assignment_action_id = p_action_context_id
688: AND paa.assignment_id = pai.Assignment_ID
689: ));
690: */

Line 707: ,pay_assignment_actions paa

703: --,pai1.action_information8 record_count
704: ,sum(fnd_number.canonical_to_number(pai1.action_information4)) value
705: FROM pay_action_information pai
706: ,pay_action_information pai1
707: ,pay_assignment_actions paa
708: WHERE pai.action_context_type = 'PA'
709: AND pai.action_information_category = p_pa_category
710: AND pai1.action_context_type = 'AAP'
711: AND pai.action_information5 <> 'F'

Line 714: FROM pay_assignment_actions paa

710: AND pai1.action_context_type = 'AAP'
711: AND pai.action_information5 <> 'F'
712: AND pai1.action_information3 <> 'F'
713: AND ( pai1.action_context_id in ( SELECT paa.assignment_action_id
714: FROM pay_assignment_actions paa
715: WHERE paa.source_action_id = p_action_context_id
716: AND paa.assignment_id = pai1.assignment_id
717: )
718: OR pai1.action_context_id = p_action_context_id)

Line 749: ,pay_assignment_actions paa

745: --,sum(pai1.action_information4) value
746: ,pai1.action_information4 value
747: FROM pay_action_information pai
748: ,pay_action_information pai1
749: ,pay_assignment_actions paa
750: WHERE pai.action_context_type = 'PA'
751: AND pai.action_information_category = p_pa_category
752: AND pai1.action_context_type = 'AAP'
753: AND pai.action_information5 = 'F'

Line 756: FROM pay_assignment_actions paa

752: AND pai1.action_context_type = 'AAP'
753: AND pai.action_information5 = 'F'
754: AND pai1.action_information3 = 'F'
755: AND ( pai1.action_context_id in ( SELECT paa.assignment_action_id
756: FROM pay_assignment_actions paa
757: WHERE paa.source_action_id = p_action_context_id
758: AND paa.assignment_id = pai1.assignment_id
759: )
760: OR pai1.action_context_id = p_action_context_id)