DBA Data[Home] [Help]

APPS.PN_VAR_TRX_PKG dependencies on PN_VAR_DEDUCTIONS_ALL

Line 4495: pn_var_deductions_all dedc

4491: ,p_grp_id IN NUMBER) IS
4492: SELECT
4493: SUM(deduction_amount) AS calc_prd_dedc
4494: FROM
4495: pn_var_deductions_all dedc
4496: WHERE
4497: dedc.period_id = p_prd_id AND
4498: dedc.line_item_id = p_line_id AND
4499: dedc.grp_date_id = p_grp_id;

Line 4512: pn_var_deductions_all dedc

4508: dedc.deduction_amount
4509: ,dedc.start_date
4510: ,dedc.end_date
4511: FROM
4512: pn_var_deductions_all dedc
4513: WHERE
4514: dedc.period_id = p_prd_id AND
4515: dedc.line_item_id = p_line_id AND
4516: dedc.grp_date_id = p_grp_id AND

Line 4632: pn_var_deductions_all dedc

4628: ,p_grp_id IN NUMBER) IS
4629: SELECT
4630: SUM(deduction_amount) AS calc_prd_dedc
4631: FROM
4632: pn_var_deductions_all dedc
4633: WHERE
4634: dedc.period_id = p_prd_id AND
4635: dedc.line_item_id = p_line_id AND
4636: dedc.grp_date_id = p_grp_id;

Line 4649: pn_var_deductions_all dedc

4645: dedc.deduction_amount
4646: ,dedc.start_date
4647: ,dedc.end_date
4648: FROM
4649: pn_var_deductions_all dedc
4650: WHERE
4651: dedc.period_id = p_prd_id AND
4652: dedc.line_item_id = p_line_id AND
4653: dedc.grp_date_id = p_grp_id AND