APPS.PAY_AU_SGC_PKG dependencies on PAY_DEFINED_BALANCES

Line 36: g_super_guarantee_bal_id_mtd pay_defined_balances.defined_balance_id%type; --2610141

32: g_age number;
33: g_age_min number;
34: g_min_hrs_worked number;
35: g_qtd_threshold number;
36: g_super_guarantee_bal_id_mtd pay_defined_balances.defined_balance_id%type; --2610141
37: g_end_date hr_organization_information.org_information10%type;
38:
39:
40: ---------------------Cursor to select balance id and superable salary ----------------

Line 74: pay_defined_balances pdb

70: is
71: select pdb.defined_balance_id
72: FROM pay_balance_types pbt,
73: pay_balance_dimensions pbd,
74: pay_defined_balances pdb
75: where pbt.balance_type_id=c_balance_type_id
76: AND nvl(pbt.legislation_code,'AU')=c_legislation_code
77: AND pbd.database_item_suffix = '_ASG_LE_MTD'
78: AND pbt.balance_type_id = pdb.balance_type_id

Line 90: pay_defined_balances pdb

86: is
87: select pdb.defined_balance_id
88: FROM pay_balance_types pbt,
89: pay_balance_dimensions pbd,
90: pay_defined_balances pdb
91: where pbt.balance_type_id=c_balance_type_id
92: AND nvl(pbt.legislation_code,'AU')=c_legislation_code
93: AND pbd.database_item_suffix = '_ASG_LE_QTD'
94: AND pbt.balance_type_id = pdb.balance_type_id