DBA Data[Home] [Help]

APPS.PQP_US_SRS_EXTRACTS dependencies on PAY_BALANCE_TYPES

Line 95: from pay_balance_types pbt

91: cursor csr_defined_bal ( c_balance_name in varchar2
92: ,c_dimension_name in varchar2
93: ,c_business_group_id in number) is
94: select db.defined_balance_id
95: from pay_balance_types pbt
96: ,pay_defined_balances db
97: ,pay_balance_dimensions bd
98: where pbt.balance_name = c_balance_name
99: and pbt.balance_type_id = db.balance_type_id

Line 277: ,p_balance_name In pay_balance_types.balance_name%TYPE

273: ,p_person_identifier In out nocopy Varchar2 ) Return Number;
274:
275: Function Get_SRS_Deduction_Balances
276: (p_assignment_id In per_all_assignments_f.assignment_id%TYPE
277: ,p_balance_name In pay_balance_types.balance_name%TYPE
278: ,p_balance_amount In out nocopy Number
279: ) Return Number;
280:
281: Function Get_Balance_Value