APPS.PAY_JP_RETRO_PKG dependencies on PAY_BALANCE_TYPES

Line 79: -- from pay_balance_types

75:
76: --
77: --cursor csr_sg_sal_si is
78: -- select balance_type_id
79: -- from pay_balance_types
80: -- where balance_name = g_sal;
81: --cursor csr_sg_sal_material_si is
82: -- select balance_type_id
83: -- from pay_balance_types

Line 83: -- from pay_balance_types

79: -- from pay_balance_types
80: -- where balance_name = g_sal;
81: --cursor csr_sg_sal_material_si is
82: -- select balance_type_id
83: -- from pay_balance_types
84: -- where balance_name = g_material;
85: -- --cursor csr_sg_payment_days is
86: -- -- select balance_type_id
87: -- -- from pay_balance_types

Line 87: -- -- from pay_balance_types

83: -- from pay_balance_types
84: -- where balance_name = g_material;
85: -- --cursor csr_sg_payment_days is
86: -- -- select balance_type_id
87: -- -- from pay_balance_types
88: -- -- where balance_name = g_payment_days;
89: -- --cursor csr_sg_fixed_sal is
90: -- -- select balance_type_id
91: -- -- from pay_balance_types

Line 91: -- -- from pay_balance_types

87: -- -- from pay_balance_types
88: -- -- where balance_name = g_payment_days;
89: -- --cursor csr_sg_fixed_sal is
90: -- -- select balance_type_id
91: -- -- from pay_balance_types
92: -- -- where balance_name = g_fixed_sal;
93: BEGIN
94: p_apply_mth := to_char(p_date_earned, 'YYYY-MM');
95: l_apply_mth_3 := to_char(add_months(p_date_earned, -3), 'YYYY-MM');

Line 357: from pay_balance_types

353: l_value number;
354:
355: cursor csr_sg_sal is
356: select balance_name
357: from pay_balance_types
358: where balance_type_id = g_sal_id;
359: cursor csr_sg_sal_material is
360: select balance_name
361: from pay_balance_types

Line 361: from pay_balance_types

357: from pay_balance_types
358: where balance_type_id = g_sal_id;
359: cursor csr_sg_sal_material is
360: select balance_name
361: from pay_balance_types
362: where balance_type_id = g_material_id;
363: -- --cursor csr_sg_payment_days is
364: -- -- select balance_name
365: -- -- from pay_balance_types

Line 365: -- -- from pay_balance_types

361: from pay_balance_types
362: where balance_type_id = g_material_id;
363: -- --cursor csr_sg_payment_days is
364: -- -- select balance_name
365: -- -- from pay_balance_types
366: -- -- where balance_type_id = g_payment_days_id;
367: -- --cursor csr_sg_fixed_sal is
368: -- -- select balance_name
369: -- -- from pay_balance_types

Line 369: -- -- from pay_balance_types

365: -- -- from pay_balance_types
366: -- -- where balance_type_id = g_payment_days_id;
367: -- --cursor csr_sg_fixed_sal is
368: -- -- select balance_name
369: -- -- from pay_balance_types
370: -- -- where balance_type_id = g_fixed_sal_id;
371: BEGIN
372: l_value := 0;
373: