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

Line 267: l_actid pay_assignment_actions.assignment_action_id%TYPE;

263: -- Local Variable
264:
265: l_proc VARCHAR2(60):=g_package||'.assignment_action_code ';
266:
267: l_actid pay_assignment_actions.assignment_action_id%TYPE;
268:
269: --
270: -- Do not process child assignment actions here these will be
271: -- explicitly created in ARCHIVE_CODE

Line 285: FROM pay_assignment_actions assact

281: SELECT /*+ ORDERED */ assact.assignment_id
282: , assact.assignment_action_id
283: , assact.tax_unit_id establishment_id
284: , payact.action_type
285: FROM pay_assignment_actions assact
286: , pay_payroll_actions payact
287: , hr_organization_information cmp_check
288: WHERE assact.source_action_id is null
289: AND assact.action_status = 'C'

Line 329: , pay_assignment_actions assact

325: , payact.action_type
326: FROM pay_population_ranges pop
327: , per_periods_of_service pos
328: , per_all_assignments_f asg
329: , pay_assignment_actions assact
330: , pay_payroll_actions payact
331: , hr_organization_information cmp_check
332: WHERE pop.payroll_action_id = p_payroll_action_id
333: and pop.chunk_number = p_chunk

Line 366: , pay_assignment_actions assact

362: --
363: CURSOR csr_locking_archive(p_run_act_id number) is
364: SELECT /*+ ORDERED */ 1
365: FROM pay_action_interlocks plock
366: , pay_assignment_actions assact
367: , pay_action_information actinfo
368: WHERE plock.locked_action_id = p_run_act_id
369: AND plock.locking_action_id = assact.assignment_action_id
370: AND assact.payroll_action_id = actinfo.action_context_id

Line 437: SELECT pay_assignment_actions_s.nextval

433: close csr_locking_archive;
434: end if;
435: if l_create_act then
436: -- insert the new assignment action
437: SELECT pay_assignment_actions_s.nextval
438: INTO l_actid
439: FROM dual;
440: hr_nonrun_asact.insact( l_actid
441: , rec_assact.assignment_id

Line 517: , pay_assignment_actions locked_assact

513: SELECT payact.action_type type,
514: locked_assact.assignment_action_id id,
515: locked_assact.tax_unit_id
516: FROM pay_action_interlocks interlock
517: , pay_assignment_actions locked_assact
518: , pay_payroll_actions payact
519: WHERE interlock.locking_action_id = p_assignment_action_id
520: AND interlock.locked_action_id = locked_assact.assignment_action_id
521: AND locked_assact.payroll_action_id = payact.payroll_action_id;

Line 526: , pay_assignment_actions rev_assact

522: --
523: CURSOR csr_locking_reversal (p_run_act_id number) is
524: SELECT 1 /* if the run action is reversed exclude it */
525: FROM pay_action_interlocks rev_interlock
526: , pay_assignment_actions rev_assact
527: , pay_payroll_actions rev_payact
528: WHERE rev_interlock.locked_action_id = p_run_act_id
529: AND rev_interlock.locking_action_id = rev_assact.assignment_action_id
530: AND rev_assact.action_status = 'C'

Line 541: ,pay_assignment_actions_s.nextval new_ass_act_id

537: ,runchild.payroll_action_id
538: ,runchild.assignment_action_id
539: ,runchild.assignment_id
540: ,runchild.tax_unit_id
541: ,pay_assignment_actions_s.nextval new_ass_act_id
542: FROM pay_assignment_actions assact
543: ,pay_action_interlocks interlock
544: ,pay_assignment_actions runchild
545: WHERE assact.assignment_action_id = p_assignment_action_id

Line 542: FROM pay_assignment_actions assact

538: ,runchild.assignment_action_id
539: ,runchild.assignment_id
540: ,runchild.tax_unit_id
541: ,pay_assignment_actions_s.nextval new_ass_act_id
542: FROM pay_assignment_actions assact
543: ,pay_action_interlocks interlock
544: ,pay_assignment_actions runchild
545: WHERE assact.assignment_action_id = p_assignment_action_id
546: AND interlock.locking_action_id = assact.assignment_action_id

Line 544: ,pay_assignment_actions runchild

540: ,runchild.tax_unit_id
541: ,pay_assignment_actions_s.nextval new_ass_act_id
542: FROM pay_assignment_actions assact
543: ,pay_action_interlocks interlock
544: ,pay_assignment_actions runchild
545: WHERE assact.assignment_action_id = p_assignment_action_id
546: AND interlock.locking_action_id = assact.assignment_action_id
547: AND interlock.locked_action_id = runchild.source_action_id;
548:

Line 552: ,pay_assignment_actions_s.nextval new_ass_act_id

548:
549: CURSOR csr_grand_child (p_child_action_id in number) is
550: SELECT assact.assignment_action_id
551: ,assact.tax_unit_id
552: ,pay_assignment_actions_s.nextval new_ass_act_id
553: FROM pay_assignment_actions assact
554: WHERE assact.source_action_id = p_child_action_id;
555: --
556: l_locked_action csr_locked_action_info%ROWTYPE;

Line 553: FROM pay_assignment_actions assact

549: CURSOR csr_grand_child (p_child_action_id in number) is
550: SELECT assact.assignment_action_id
551: ,assact.tax_unit_id
552: ,pay_assignment_actions_s.nextval new_ass_act_id
553: FROM pay_assignment_actions assact
554: WHERE assact.source_action_id = p_child_action_id;
555: --
556: l_locked_action csr_locked_action_info%ROWTYPE;
557: --

Line 611: update pay_assignment_actions

607: p_effective_date,
608: grand_child.tax_unit_id);
609: end if; -- csr_locking_reversal%NOTFOUND
610: close csr_locking_reversal;
611: update pay_assignment_actions
612: set action_status = 'C'
613: where assignment_action_id = grand_child.new_ass_act_id;
614: END LOOP; -- grand_child
615: -- Only process the child action if it has no grand child actions

Line 627: update pay_assignment_actions

623: child.tax_unit_id);
624: end if; -- csr_locking_reversal%NOTFOUND
625: close csr_locking_reversal;
626: END IF;
627: update pay_assignment_actions
628: set action_status = 'C'
629: where assignment_action_id = child.new_ass_act_id;
630: END LOOP; -- child
631:

Line 667: l_establishment_id pay_assignment_actions.tax_unit_id%TYPE;

663:
664: l_proc VARCHAR2(60):= g_package||' retrieve_contributions ';
665:
666:
667: l_establishment_id pay_assignment_actions.tax_unit_id%TYPE;
668: l_Order_Number binary_integer;
669:
670: l_page_type pay_run_result_values.result_value%TYPE;
671: l_subpage_identifier varchar2(150);

Line 780: FROM pay_assignment_actions

776: -- and bases within an assignment action.
777: --
778: CURSOR cassact is
779: SELECT tax_unit_id
780: FROM pay_assignment_actions
781: WHERE assignment_action_id = p_assignment_action_id;
782: --
783: -- Cursor to retrieve the pension provider id
784: --

Line 999: ,pay_assignment_actions pac

995:
996: CURSOR cur_per IS
997: SELECT distinct paa.person_id
998: FROM pay_action_information pai
999: ,pay_assignment_actions pac
1000: ,per_all_assignments_f paa
1001: WHERE pac.payroll_action_id=p_payroll_action_id
1002: and pai.action_information_category = 'FR_DUCS_ACTION_CONTRIB_INFO'
1003: and pai.action_information1 = l_page_id_chr

Line 1017: ,pay_assignment_actions pac

1013: CURSOR cur_asg_count IS
1014: SELECT count(distinct pac.assignment_id),
1015: count(distinct pac.assignment_action_id)
1016: FROM pay_action_information pai
1017: ,pay_assignment_actions pac
1018: WHERE pac.payroll_action_id=p_payroll_action_id
1019: and pai.action_information_category = 'FR_DUCS_ACTION_CONTRIB_INFO'
1020: and pai.action_information1 = l_page_id_chr
1021: and pai.action_information2 = p_page_type

Line 1172: FROM pay_assignment_actions assact

1168: , round(sum(fnd_number.canonical_to_number(contrib.action_information5))) base
1169: , fnd_number.canonical_to_number(contrib.action_information6) rate
1170: , sum(fnd_number.canonical_to_number(contrib.action_information7)) pay_value
1171: , count(distinct assact.assignment_id) number_of_employees
1172: FROM pay_assignment_actions assact
1173: , pay_action_information contrib
1174: WHERE
1175: assact.payroll_action_id in
1176: (SELECT payroll_action_id

Line 1217: , pay_assignment_actions assact

1213: , fnd_number.canonical_to_number(contrib.action_information6) rate
1214: , sum(fnd_number.canonical_to_number(contrib.action_information7)) pay_value
1215: , count(distinct assact.assignment_id) number_of_employees
1216: FROM pay_payroll_actions payact
1217: , pay_assignment_actions assact
1218: , pay_action_information contrib
1219: WHERE assact.payroll_action_id = payact.payroll_action_id
1220: and payact.report_type = 'DUCS_ARCHIVE'
1221: and payact.report_qualifier = 'FR'