APPS.PY_ZA_TAX_REG dependencies on PAY_BALANCE_TYPES

Line 190: p_balance_name IN pay_balance_types.balance_name%TYPE

186: -------------------------------------------------------------------------------
187: -- balance_id
188: -------------------------------------------------------------------------------
189: FUNCTION balance_id (
190: p_balance_name IN pay_balance_types.balance_name%TYPE
191: )
192: RETURN pay_balance_types.balance_type_id%TYPE
193: AS
194: ---------

Line 192: RETURN pay_balance_types.balance_type_id%TYPE

188: -------------------------------------------------------------------------------
189: FUNCTION balance_id (
190: p_balance_name IN pay_balance_types.balance_name%TYPE
191: )
192: RETURN pay_balance_types.balance_type_id%TYPE
193: AS
194: ---------
195: -- Cursor
196: ---------

Line 198: p_balance_name IN pay_balance_types.balance_name%TYPE

194: ---------
195: -- Cursor
196: ---------
197: CURSOR csr_balance_id (
198: p_balance_name IN pay_balance_types.balance_name%TYPE
199: )
200: IS
201: SELECT
202: pbt.balance_type_id

Line 204: pay_balance_types pbt

200: IS
201: SELECT
202: pbt.balance_type_id
203: FROM
204: pay_balance_types pbt
205: WHERE
206: pbt.balance_name = p_balance_name
207: AND pbt.business_group_id IS NULL
208: AND pbt.legislation_code = 'ZA';

Line 213: l_retval pay_balance_types.balance_type_id%TYPE;

209:
210: ------------
211: -- Variables
212: ------------
213: l_retval pay_balance_types.balance_type_id%TYPE;
214:
215: -------------------------------------------------------------------------------
216: BEGIN -- MAIN --
217: -------------------------------------------------------------------------------

Line 241: , p_balance_type_id IN pay_balance_types.balance_type_id%TYPE

237: -------------------------------------------------------------------------------
238: FUNCTION ptd_value (
239: p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
240: , p_action_period_id IN per_time_periods.time_period_id%TYPE
241: , p_balance_type_id IN pay_balance_types.balance_type_id%TYPE
242: , p_balance_name IN pay_za_irp5_bal_codes.full_balance_name%TYPE
243: , p_effective_date IN pay_payroll_actions.effective_date%TYPE
244: )
245: RETURN NUMBER AS

Line 301: , p_balance_type_id IN pay_balance_types.balance_type_id%TYPE

297: -- mtd_value
298: -------------------------------------------------------------------------------
299: FUNCTION mtd_value (
300: p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
301: , p_balance_type_id IN pay_balance_types.balance_type_id%TYPE
302: , p_balance_name IN pay_za_irp5_bal_codes.full_balance_name%TYPE
303: , p_effective_date IN pay_payroll_actions.effective_date%TYPE
304: )
305: RETURN NUMBER AS

Line 363: , p_balance_type_id IN pay_balance_types.balance_type_id%TYPE

359: -- ytd_value
360: -------------------------------------------------------------------------------
361: FUNCTION ytd_value (
362: p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
363: , p_balance_type_id IN pay_balance_types.balance_type_id%TYPE
364: , p_effective_date IN pay_payroll_actions.effective_date%TYPE
365: )
366: RETURN NUMBER AS
367: ------------

Line 733: l_bal_type_id pay_balance_types.balance_type_id%TYPE;

729: AS
730: ------------
731: -- Variables
732: ------------
733: l_bal_type_id pay_balance_types.balance_type_id%TYPE;
734: l_balance_value NUMBER;
735: -------------------------------------------------------------------------------
736: BEGIN -- MAIN --
737: -------------------------------------------------------------------------------