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 57: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

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

Line 714: pay_assignment_actions paa,

710: is
711: select distinct per_information2, paa.tax_unit_id,
712: assignment_action_id assignment_action_id
713: from pay_payroll_actions ppa,
714: pay_assignment_actions paa,
715: per_people_f pap,
716: per_assignments_f paf
717: where paa.payroll_action_id = ppa.payroll_action_id
718: and pap.person_id = paf.person_id

Line 890: pay_assignment_actions paa,

886: from per_people_f pap,
887: per_assignments_f paaf,
888: pay_payroll_actions ppa,
889: pay_payroll_actions ppa1,
890: pay_assignment_actions paa,
891: pay_assignment_actions paa2,
892: per_periods_of_service pps
893: where ppa.payroll_action_id = p_payroll_action_id
894: and paa.assignment_id = paaf.assignment_id

Line 891: pay_assignment_actions paa2,

887: per_assignments_f paaf,
888: pay_payroll_actions ppa,
889: pay_payroll_actions ppa1,
890: pay_assignment_actions paa,
891: pay_assignment_actions paa2,
892: per_periods_of_service pps
893: where ppa.payroll_action_id = p_payroll_action_id
894: and paa.assignment_id = paaf.assignment_id
895: and paa2.assignment_id = paaf.assignment_id

Line 954: select pay_assignment_actions_s.nextval

950:
951:
952:
953: cursor csr_next_action_id is
954: select pay_assignment_actions_s.nextval
955: from dual;
956:
957: l_next_assignment_action_id pay_assignment_actions.assignment_action_id%type;
958: l_procedure varchar2(200) ;

Line 957: l_next_assignment_action_id pay_assignment_actions.assignment_action_id%type;

953: cursor csr_next_action_id is
954: select pay_assignment_actions_s.nextval
955: from dual;
956:
957: l_next_assignment_action_id pay_assignment_actions.assignment_action_id%type;
958: l_procedure varchar2(200) ;
959: i number;
960:
961: l_action_information_id number;

Line 1069: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type

1065: raise;
1066: end assignment_action_code;
1067:
1068: procedure archive_code
1069: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
1070: ,p_effective_date in pay_payroll_actions.effective_date%type
1071: ) is
1072:
1073: /* 5893671*/

Line 1122: pay_assignment_actions paa,

1118: from per_people_f pap,
1119: per_assignments_f paaf,
1120: pay_payroll_actions ppa,
1121: pay_payroll_actions ppa1,
1122: pay_assignment_actions paa,
1123: pay_assignment_actions paa2,
1124: hr_soft_coding_keyflex hsc,
1125: hr_organization_units hou,
1126: hr_organization_units hou1,

Line 1123: pay_assignment_actions paa2,

1119: per_assignments_f paaf,
1120: pay_payroll_actions ppa,
1121: pay_payroll_actions ppa1,
1122: pay_assignment_actions paa,
1123: pay_assignment_actions paa2,
1124: hr_soft_coding_keyflex hsc,
1125: hr_organization_units hou,
1126: hr_organization_units hou1,
1127: hr_organization_information hoi,