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.PER_AE_WAGE_PROTECTION_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 38: p_business_group_id in per_all_assignments_f.business_group_id%type

34: (
35: p_month in varchar2,
36: p_year in varchar2,
37: p_employer_id in number,
38: p_business_group_id in per_all_assignments_f.business_group_id%type
39: ) return number
40: is
41:
42: begin

Line 45: FROM per_all_assignments_f asg

41:
42: begin
43: SELECT count(distinct asg.assignment_id)
44: into l_cnt_emps
45: FROM per_all_assignments_f asg
46: ,pay_assignment_actions paa
47: ,pay_payroll_actions ppa
48: ,hr_soft_coding_keyflex hscl
49: ,per_periods_of_service pos

Line 76: p_business_group_id in per_all_assignments_f.business_group_id%type

72: (
73: p_month in varchar2,
74: p_year in varchar2,
75: p_employer_id in number,
76: p_business_group_id in per_all_assignments_f.business_group_id%type
77: ) return number
78: is
79: begin
80: select count(distinct asg.assignment_id), NVL(sum(ppv.value),0)

Line 82: from per_all_assignments_f asg,

78: is
79: begin
80: select count(distinct asg.assignment_id), NVL(sum(ppv.value),0)
81: into l_cnt_emp_paid, l_amt_paid
82: from per_all_assignments_f asg,
83: pay_assignment_actions paa,
84: pay_payroll_actions ppa,
85: PAY_PRE_PAYMENTS_V ppv,
86: hr_soft_coding_keyflex hscl,