DBA Data[Home] [Help]

APPS.PAY_IE_P30LOCK dependencies on PAY_BALANCE_TYPES

Line 421: vp_Balance_Name Pay_Balance_Types.Balance_Name%TYPE,

417: /* YTD_Balances fill fetch that balance value whose source ids effective date is less than effective date
418: of P30 datalock */
419: CURSOR YTD_Balances (vp_Payroll_Action_Id Pay_Payroll_Actions.Payroll_Action_ID%TYPE,
420: vp_Assignment_Id Pay_Assignment_Actions.Assignment_Action_ID%TYPE,
421: vp_Balance_Name Pay_Balance_Types.Balance_Name%TYPE,
422: vp_Dimension_Name varchar2,
423: vp_action_context_id number,
424: vp_effective_date date)IS -- SR 17318286.6 rbhardwa
425: SELECT pact_ytdbal.action_information4 Balance_Value

Line 431: pay_balance_types pbt_ytdbal,

427: pay_action_interlocks pai_p30,
428: pay_assignment_actions paa_arc,
429: pay_action_information pact_ytdbal,
430: pay_defined_balances pdb_ytdbal,
431: pay_balance_types pbt_ytdbal,
432: pay_balance_dimensions pbd_ytdbal,
433: pay_assignment_actions paa_src,
434: pay_payroll_actions ppa_src
435: WHERE paa_p30.payroll_action_id = vp_Payroll_Action_Id