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

Line 56: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

52:
53: /* Procedure to pass all the balance results back in one call from report */
54:
55: procedure get_balances
56: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
57: p_registered_employer in NUMBER,
58: p_tax_state in varchar2,
59: p_salaries_wages out NOCOPY number,
60: p_commission out NOCOPY number,

Line 416: pay_assignment_actions paa,

412: is
413: select distinct per_information2, paa.tax_unit_id,
414: assignment_action_id assignment_action_id
415: from pay_payroll_actions ppa,
416: pay_assignment_actions paa,
417: per_people_f pap,
418: per_assignments_f paf
419: where paa.payroll_action_id = ppa.payroll_action_id
420: and pap.person_id = paf.person_id

Line 589: pay_assignment_actions paa,

585: from per_people_f pap,
586: per_assignments_f paaf,
587: pay_payroll_actions ppa,
588: pay_payroll_actions ppa1,
589: pay_assignment_actions paa,
590: pay_assignment_actions paa2,
591: per_periods_of_service pps
592: where ppa.payroll_action_id = p_payroll_action_id
593: and paa.assignment_id = paaf.assignment_id

Line 590: pay_assignment_actions paa2,

586: per_assignments_f paaf,
587: pay_payroll_actions ppa,
588: pay_payroll_actions ppa1,
589: pay_assignment_actions paa,
590: pay_assignment_actions paa2,
591: per_periods_of_service pps
592: where ppa.payroll_action_id = p_payroll_action_id
593: and paa.assignment_id = paaf.assignment_id
594: and paa2.assignment_id = paaf.assignment_id

Line 653: select pay_assignment_actions_s.nextval

649:
650:
651:
652: cursor csr_next_action_id is
653: select pay_assignment_actions_s.nextval
654: from dual;
655:
656: l_next_assignment_action_id pay_assignment_actions.assignment_action_id%type;
657: l_procedure varchar2(200) ;

Line 656: l_next_assignment_action_id pay_assignment_actions.assignment_action_id%type;

652: cursor csr_next_action_id is
653: select pay_assignment_actions_s.nextval
654: from dual;
655:
656: l_next_assignment_action_id pay_assignment_actions.assignment_action_id%type;
657: l_procedure varchar2(200) ;
658: i number;
659:
660: l_action_information_id number;

Line 768: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type

764: raise;
765: end assignment_action_code;
766:
767: procedure archive_code
768: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
769: ,p_effective_date in pay_payroll_actions.effective_date%type
770: ) is
771:
772: /* 5893671*/

Line 821: pay_assignment_actions paa,

817: from per_people_f pap,
818: per_assignments_f paaf,
819: pay_payroll_actions ppa,
820: pay_payroll_actions ppa1,
821: pay_assignment_actions paa,
822: pay_assignment_actions paa2,
823: hr_soft_coding_keyflex hsc,
824: hr_organization_units hou,
825: hr_organization_units hou1,

Line 822: pay_assignment_actions paa2,

818: per_assignments_f paaf,
819: pay_payroll_actions ppa,
820: pay_payroll_actions ppa1,
821: pay_assignment_actions paa,
822: pay_assignment_actions paa2,
823: hr_soft_coding_keyflex hsc,
824: hr_organization_units hou,
825: hr_organization_units hou1,
826: hr_organization_information hoi,