APPS.PAY_MX_YEAREND_REP dependencies on HR_UTILITY

Line 39: hr_utility.trace('Inside pay_mx_yearend_rep.get_ye_arch_bal_amt');

35: l_bal_amt number := 0;
36:
37: BEGIN
38:
39: hr_utility.trace('Inside pay_mx_yearend_rep.get_ye_arch_bal_amt');
40: hr_utility.trace('ye_payroll_action_id : '||ye_payroll_action_id);
41: hr_utility.trace('ye_person_id : '||ye_person_id);
42: hr_utility.trace('ye_effective_date : '||ye_effective_date);
43: hr_utility.trace('ye_balance_name : '||ye_balance_name);

Line 40: hr_utility.trace('ye_payroll_action_id : '||ye_payroll_action_id);

36:
37: BEGIN
38:
39: hr_utility.trace('Inside pay_mx_yearend_rep.get_ye_arch_bal_amt');
40: hr_utility.trace('ye_payroll_action_id : '||ye_payroll_action_id);
41: hr_utility.trace('ye_person_id : '||ye_person_id);
42: hr_utility.trace('ye_effective_date : '||ye_effective_date);
43: hr_utility.trace('ye_balance_name : '||ye_balance_name);
44:

Line 41: hr_utility.trace('ye_person_id : '||ye_person_id);

37: BEGIN
38:
39: hr_utility.trace('Inside pay_mx_yearend_rep.get_ye_arch_bal_amt');
40: hr_utility.trace('ye_payroll_action_id : '||ye_payroll_action_id);
41: hr_utility.trace('ye_person_id : '||ye_person_id);
42: hr_utility.trace('ye_effective_date : '||ye_effective_date);
43: hr_utility.trace('ye_balance_name : '||ye_balance_name);
44:
45: select round(SUM(nvl(fnd_number.canonical_to_number(fai.value),0)))

Line 42: hr_utility.trace('ye_effective_date : '||ye_effective_date);

38:
39: hr_utility.trace('Inside pay_mx_yearend_rep.get_ye_arch_bal_amt');
40: hr_utility.trace('ye_payroll_action_id : '||ye_payroll_action_id);
41: hr_utility.trace('ye_person_id : '||ye_person_id);
42: hr_utility.trace('ye_effective_date : '||ye_effective_date);
43: hr_utility.trace('ye_balance_name : '||ye_balance_name);
44:
45: select round(SUM(nvl(fnd_number.canonical_to_number(fai.value),0)))
46: into l_bal_amt

Line 43: hr_utility.trace('ye_balance_name : '||ye_balance_name);

39: hr_utility.trace('Inside pay_mx_yearend_rep.get_ye_arch_bal_amt');
40: hr_utility.trace('ye_payroll_action_id : '||ye_payroll_action_id);
41: hr_utility.trace('ye_person_id : '||ye_person_id);
42: hr_utility.trace('ye_effective_date : '||ye_effective_date);
43: hr_utility.trace('ye_balance_name : '||ye_balance_name);
44:
45: select round(SUM(nvl(fnd_number.canonical_to_number(fai.value),0)))
46: into l_bal_amt
47: from pay_assignment_actions paa,

Line 88: hr_utility.trace('l_bal_amt : '||l_bal_amt);

84: AND NVL(hier_ver.date_to,
85: hr_general.end_of_time))
86: and fue.user_entity_name = ye_balance_name ;
87:
88: hr_utility.trace('l_bal_amt : '||l_bal_amt);
89:
90: return(l_bal_amt);
91:
92: