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_CA_GROUP_LEVEL_BAL_PKG dependencies on PAY_CA_GROUP_LEVEL_BAL_PKG

Line 1: PACKAGE BODY pay_ca_group_level_bal_pkg AS

1: PACKAGE BODY pay_ca_group_level_bal_pkg AS
2: /* $Header: pycatxbv.pkb 120.1.12000000.1 2007/01/17 17:37:22 appldev noship $ */
3:
4: -------------------------------------------------------------------------------
5: -- Name: get_date_mask

Line 17: l_routine_name VARCHAR2(64) := 'pay_ca_group_level_bal_pkg.get_date_mask';

13: -------------------------------------------------------------------------------
14: FUNCTION get_date_mask (p_time_dimension VARCHAR2) RETURN VARCHAR2 IS
15:
16: l_date_mask VARCHAR2(5) := '';
17: l_routine_name VARCHAR2(64) := 'pay_ca_group_level_bal_pkg.get_date_mask';
18:
19: BEGIN
20: hr_utility.trace('Starting routine: '||l_routine_name);
21:

Line 66: l_routine_name VARCHAR2(64):='pay_ca_group_level_bal_pkg.get_asg_virtual_date';

62: AND asg.payroll_id IS NOT NULL
63: AND asg.effective_end_date BETWEEN TRUNC(p_date, p_date_mask)
64: AND p_date;
65:
66: l_routine_name VARCHAR2(64):='pay_ca_group_level_bal_pkg.get_asg_virtual_date';
67:
68: l_asg_virtual_date DATE;
69: e_no_valid_date_exists EXCEPTION;
70:

Line 132: l_routine_name VARCHAR2(64):='pay_ca_group_level_bal_pkg.get_virtual_date';

128: AND asg.payroll_id = pay.payroll_id
129: AND pay.effective_end_date BETWEEN TRUNC(p_date, p_date_mask)
130: AND p_date;
131:
132: l_routine_name VARCHAR2(64):='pay_ca_group_level_bal_pkg.get_virtual_date';
133:
134: l_asg_in_payroll VARCHAR2(1);
135: l_virtual_date DATE;
136: l_altered_date DATE;

Line 221: l_routine_name VARCHAR2(64) := 'pay_ca_group_level_bal_pkg.get_defined_balance';

217: OR bld.business_group_id = p_bus_grp_id))
218: AND (dbl.legislation_code = 'CA'
219: OR dbl.business_group_id = p_bus_grp_id);
220:
221: l_routine_name VARCHAR2(64) := 'pay_ca_group_level_bal_pkg.get_defined_balance';
222:
223: l_defined_balance_id NUMBER;
224: l_business_group_id NUMBER;
225:

Line 453: 'pay_ca_group_level_bal_pkg.get_grp_pydate_with_aa';

449: OR (p_basis_type IS NULL));
450:
451:
452: l_routine_name VARCHAR2(64) :=
453: 'pay_ca_group_level_bal_pkg.get_grp_pydate_with_aa';
454:
455: l_lb_defined_balance_id NUMBER(9);
456: l_balance_value NUMBER(38,10) := 0;
457: l_run_dimension VARCHAR2(30);

Line 768: 'pay_ca_group_level_bal_pkg.get_grp_pydate_with_aa_rb';

764: OR (p_basis_type IS NULL));
765:
766:
767: l_routine_name VARCHAR2(64) :=
768: 'pay_ca_group_level_bal_pkg.get_grp_pydate_with_aa_rb';
769:
770: l_lb_defined_balance_id NUMBER(9);
771: l_balance_value NUMBER(38,10) := 0;
772: l_run_dimension VARCHAR2(30);

Line 1213: l_routine_name VARCHAR2(64) := 'pay_ca_group_level_bal_pkg.get_grp_non_pydate_with_asg';

1209: ('ANNUAL','MONTHLY','PERIOD')))
1210: OR (p_basis_type IS NULL));
1211:
1212:
1213: l_routine_name VARCHAR2(64) := 'pay_ca_group_level_bal_pkg.get_grp_non_pydate_with_asg';
1214:
1215: l_lb_defined_balance_id NUMBER(9);
1216: l_latest_bal_exists VARCHAR2(1);
1217: l_virtual_date DATE;

Line 1754: l_routine_name VARCHAR2(64) := 'pay_ca_group_level_bal_pkg.get_grp_non_pydate_with_asg_rb';

1750: ('ANNUAL','MONTHLY','PERIOD')))
1751: OR (p_basis_type IS NULL));
1752:
1753:
1754: l_routine_name VARCHAR2(64) := 'pay_ca_group_level_bal_pkg.get_grp_non_pydate_with_asg_rb';
1755:
1756: l_lb_defined_balance_id NUMBER(9);
1757: l_latest_bal_exists VARCHAR2(1);
1758: l_virtual_date DATE;

Line 2189: l_routine_name VARCHAR2(64) := 'pay_ca_group_level_bal_pkg.ca_group_level_balance';

2185: AND asg.effective_end_date
2186: AND ROWNUM = 1;
2187:
2188:
2189: l_routine_name VARCHAR2(64) := 'pay_ca_group_level_bal_pkg.ca_group_level_balance';
2190:
2191: l_dim_str1 VARCHAR2(60);
2192: l_gl_dimension VARCHAR2(60);
2193: l_lb_dimension VARCHAR2(60);

Line 2712: l_routine_name VARCHAR2(64) := 'pay_ca_group_level_bal_pkg.ca_group_level_balance_rb';

2708: select business_group_id
2709: from hr_all_organization_units
2710: where organization_id = cp_gre_id;
2711:
2712: l_routine_name VARCHAR2(64) := 'pay_ca_group_level_bal_pkg.ca_group_level_balance_rb';
2713:
2714: l_dim_str1 VARCHAR2(60);
2715: l_gl_dimension VARCHAR2(60);
2716: l_lb_dimension VARCHAR2(60);

Line 3105: END pay_ca_group_level_bal_pkg;

3101:
3102: END ca_group_level_balance_rb;
3103:
3104:
3105: END pay_ca_group_level_bal_pkg;
3106: