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

Line 244: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

240: -- rather than 6 separate calls.
241: ------------------------------------------------------------------------
242: procedure balance_totals
243: (p_assignment_id in per_all_assignments_f.assignment_id%type,
244: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
245: p_effective_date in date,
246: p_gross_this_pay out NOCOPY number,
247: p_other_deductions_this_pay out NOCOPY number,
248: p_tax_deductions_this_pay out NOCOPY number,

Line 274: from pay_assignment_actions paa

270:
271: /* Bug 2610141 */
272: CURSOR tax_unit_id IS
273: SELECT tax_unit_id
274: from pay_assignment_actions paa
275: where paa.assignment_action_id = p_assignment_action_id;
276:
277: /*Bug 3935483 Changes for BBR start here */
278:

Line 568: from pay_assignment_actions paa,

564: ptp.period_name,
565: rppa.payroll_id,
566: nvl(rppa.pay_advice_date,ptp.pay_advice_date),
567: rppa.pay_advice_message
568: from pay_assignment_actions paa,
569: pay_payroll_actions ppa,
570: pay_assignment_actions rpaa,
571: per_time_periods ptp,
572: pay_payroll_actions rppa

Line 570: pay_assignment_actions rpaa,

566: nvl(rppa.pay_advice_date,ptp.pay_advice_date),
567: rppa.pay_advice_message
568: from pay_assignment_actions paa,
569: pay_payroll_actions ppa,
570: pay_assignment_actions rpaa,
571: per_time_periods ptp,
572: pay_payroll_actions rppa
573: where paa.payroll_action_id = ppa.payroll_action_id
574: and rppa.payroll_action_id = rpaa.payroll_action_id

Line 579: pay_assignment_actions aa

575: and rppa.time_period_id = ptp.time_period_id
576: and paa.assignment_action_id =
577: (select to_number(substr(max(to_char(pa.effective_date,'J')||lpad(aa.assignment_action_id,15,'0')),8))
578: from pay_payroll_actions pa,
579: pay_assignment_actions aa
580: where pa.action_type in ('U','P') /* Bug No : 2674887 */
581: and aa.action_status = 'C'
582: and pa.payroll_action_id = aa.payroll_action_id
583: and aa.assignment_id = p_assignment_id

Line 589: from pay_assignment_actions aa,

585: and ppa.action_type in ('P', 'U') /* Bug No : 2674887 */
586: and rpaa.assignment_id = p_assignment_id
587: and rpaa.action_sequence =
588: (select max(aa.action_sequence)
589: from pay_assignment_actions aa,
590: pay_action_interlocks loc
591: where loc.locked_action_id = aa.assignment_action_id
592: and loc.locking_action_id = paa.assignment_action_id);
593: begin

Line 629: from pay_assignment_actions assact,

625:
626: cursor get_action_type is
627: -- find type of action this is
628: select pact.action_type , assact.assignment_id
629: from pay_assignment_actions assact,
630: pay_payroll_actions pact
631: where assact.assignment_action_id = p_assignment_action_id
632: and pact.payroll_action_id =
633: assact.payroll_action_id

Line 638: from pay_assignment_actions assact,

634: ;
635: cursor get_run is
636: -- for prepayment action find the latest interlocked run
637: select assact.assignment_action_id
638: from pay_assignment_actions assact,
639: pay_action_interlocks loc
640: where loc.locking_action_id = p_assignment_action_id
641: and assact.assignment_action_id = loc.locked_action_id
642: order by assact.action_sequence desc ;

Line 647: from pay_assignment_actions assact,

643:
644: cursor get_prepay is
645: -- for run action check if its been prepaid
646: select assact.assignment_action_id
647: from pay_assignment_actions assact,
648: pay_payroll_actions pact,
649: pay_action_interlocks loc
650: where loc.locked_action_id = p_assignment_action_id
651: and assact.assignment_action_id = loc.locking_action_id

Line 667: from pay_assignment_actions assact,

663: ptp.time_period_id,
664: ptp.period_name,
665: nvl(pact.pay_advice_date,ptp.pay_advice_date),
666: pay_advice_message
667: from pay_assignment_actions assact,
668: pay_payroll_actions pact,
669: per_time_periods ptp
670: where assact.assignment_action_id = p_run_assignment_action_id
671: and pact.payroll_action_id = assact.payroll_action_id

Line 717: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

713: p_fetch_only_ytd_value to fetch only ytd balances and not run balances */
714:
715: procedure final_balance_totals
716: (p_assignment_id in per_all_assignments_f.assignment_id%type,
717: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
718: p_effective_date in date,
719: p_gross_this_pay out NOCOPY number,
720: p_other_deductions_this_pay out NOCOPY number,
721: p_tax_deductions_this_pay out NOCOPY number,

Line 741: FROM pay_assignment_actions paa,

737: is
738:
739: CURSOR run_ids IS
740: SELECT pai.locked_action_id
741: FROM pay_assignment_actions paa,
742: pay_action_interlocks pai
743: WHERE pai.LOCKING_ACTION_ID = p_assignment_action_id
744: AND pai.locked_action_id = paa.assignment_action_id
745: AND paa.assignment_action_id not in (select bpaa.source_action_id

Line 746: from pay_assignment_actions bpaa

742: pay_action_interlocks pai
743: WHERE pai.LOCKING_ACTION_ID = p_assignment_action_id
744: AND pai.locked_action_id = paa.assignment_action_id
745: AND paa.assignment_action_id not in (select bpaa.source_action_id
746: from pay_assignment_actions bpaa
747: where bpaa.source_action_id =pai.locked_action_id)
748: ORDER BY locked_action_id ASC;
749:
750: /*SELECT locked_action_id Bug 3245909 To fetch Master locked action_id only */

Line 751: /* FROM pay_assignment_actions paa,

747: where bpaa.source_action_id =pai.locked_action_id)
748: ORDER BY locked_action_id ASC;
749:
750: /*SELECT locked_action_id Bug 3245909 To fetch Master locked action_id only */
751: /* FROM pay_assignment_actions paa,
752: pay_action_interlocks pai
753: WHERE LOCKING_ACTION_ID = p_assignment_action_id
754: AND pai.locked_action_id = paa.assignment_action_id
755: AND paa.source_action_id IS NULL

Line 864: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

860: function super_fund_name
861: (p_source_id in number,
862: p_element_reporting_name in pay_element_types_f.reporting_name%type,
863: p_date_earned in pay_payroll_actions.date_earned%type,
864: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
865: p_assignment_id in per_all_assignments_f.assignment_id%type,
866: p_element_entry_id in pay_element_entries_f.PERSONAL_PAYMENT_METHOD_ID%TYPE,
867: p_business_group_id per_all_assignments_f.business_group_id%TYPE)
868: return varchar2

Line 1129: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,

1125: */
1126:
1127: FUNCTION get_element_payment_hours
1128: (
1129: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
1130: p_element_type_id IN pay_element_entries_f.element_entry_id%TYPE,
1131: p_pay_bases_id IN per_all_assignments_f.pay_basis_id%TYPE,
1132: p_run_result_id IN pay_run_results.run_result_ID%TYPE,
1133: p_effective_date IN pay_payroll_actions.effective_date%TYPE

Line 1244: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,

1240: */
1241:
1242: FUNCTION get_element_payment_rate
1243: (
1244: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
1245: p_element_type_id IN pay_element_entries_f.element_entry_id%TYPE,
1246: p_run_result_id IN pay_run_results.run_result_ID%TYPE,
1247: p_effective_date IN pay_payroll_actions.effective_date%TYPE
1248: )