DBA Data[Home] [Help]

APPS.PAY_NZ_EXC dependencies on PAY_BALANCE_DIMENSIONS

Line 84: l_dimension_name pay_balance_dimensions.dimension_name%type ;

80: l_owner_start date;
81: l_date_dd_mm varchar2(11);
82: l_fy_user_span_start date;
83: l_frequency number;
84: l_dimension_name pay_balance_dimensions.dimension_name%type ;
85: l_business_group_id pay_payroll_actions.business_group_id%type;
86: --
87: begin
88:

Line 289: l_dimension_name pay_balance_dimensions.dimension_name%type ;

285: , p_dimension_name in varchar2 -- balance dimension name.
286: , p_expiry_information out nocopy date -- dimension expired flag.
287: ) is
288: l_beg_of_fiscal_year date;
289: l_dimension_name pay_balance_dimensions.dimension_name%type ;
290:
291: cursor get_beg_of_fiscal_year(c_owner_payroll_action_id number) is
292: select fnd_date.canonical_to_date(org_information11)
293: from pay_payroll_actions PACT,