APPS.HR_NZ_HOLIDAYS dependencies on PAY_BALANCE_TYPES

Line 1634: FROM pay_balance_types pbt

1630:
1631:
1632: CURSOR csr_gross_earning_balance IS
1633: SELECT pbt.balance_type_id
1634: FROM pay_balance_types pbt
1635: WHERE pbt.balance_name = 'Gross Earnings for Holiday Pay'
1636: AND legislation_code = 'NZ'
1637: AND business_group_id IS NULL;
1638:

Line 2004: l_balance_type_id pay_balance_types.balance_type_id%type ;

2000: return number is
2001:
2002: l_procedure_name varchar2(61) := 'hr_nz_holidays.annual_leave_eoy_adjustment' ;
2003: l_eoy_adjustment number ;
2004: l_balance_type_id pay_balance_types.balance_type_id%type ;
2005: l_annual_leave_in_advance_hrs number ;
2006: l_annual_leave_in_advance_pay number ;
2007: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type ;
2008: l_start_date date ;

Line 2059: from pay_balance_types bt

2055:
2056: -- cursor to get ID for a balance type
2057: cursor c_balance_type(p_name varchar2) is
2058: select bt.balance_type_id
2059: from pay_balance_types bt
2060: where bt.balance_name = p_name ;
2061:
2062: -- cursor to get annual leave accrual plan
2063: cursor c_annual_leave_plan(p_assignment_id number

Line 3437: FROM pay_balance_types pbt

3433:
3434: CURSOR get_balance_id
3435: IS
3436: SELECT pbt.balance_type_id
3437: FROM pay_balance_types pbt
3438: WHERE pbt.balance_name = 'Gross Earnings for Holiday Pay'
3439: AND legislation_code = 'NZ'
3440: AND business_group_id IS NULL;
3441:

Line 3445: l_balance_type_id pay_balance_types.balance_type_id%TYPE;

3441:
3442:
3443: l_gross_earnings NUMBER;
3444: l_avg_rate NUMBER;
3445: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
3446: l_num_of_weeks NUMBER;
3447: l_year_end DATE ;
3448:
3449: BEGIN

Line 3693: from pay_balance_types

3689:
3690: e_missing_balance_type exception;
3691: CURSOR c_balance_type(p_name varchar2) is
3692: select balance_type_id
3693: from pay_balance_types
3694: where balance_name = p_name;
3695:
3696:
3697: BEGIN