DBA Data[Home] [Help]

APPS.PAY_NZ_EXC dependencies on PAY_BALANCE_DIMENSIONS

Line 86: l_dimension_name pay_balance_dimensions.dimension_name%type ;

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

Line 291: l_dimension_name pay_balance_dimensions.dimension_name%type ;

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