DBA Data[Home] [Help]

APPS.PN_VAR_TRX_PKG dependencies on PN_VAR_DEDUCTIONS_ALL

Line 4585: pn_var_deductions_all dedc

4581: ,p_grp_id IN NUMBER) IS
4582: SELECT
4583: SUM(deduction_amount) AS calc_prd_dedc
4584: FROM
4585: pn_var_deductions_all dedc
4586: WHERE
4587: dedc.period_id = p_prd_id AND
4588: dedc.line_item_id = p_line_id AND
4589: dedc.grp_date_id = p_grp_id;

Line 4602: pn_var_deductions_all dedc

4598: dedc.deduction_amount
4599: ,dedc.start_date
4600: ,dedc.end_date
4601: FROM
4602: pn_var_deductions_all dedc
4603: WHERE
4604: dedc.period_id = p_prd_id AND
4605: dedc.line_item_id = p_line_id AND
4606: dedc.grp_date_id = p_grp_id AND

Line 4722: pn_var_deductions_all dedc

4718: ,p_grp_id IN NUMBER) IS
4719: SELECT
4720: SUM(deduction_amount) AS calc_prd_dedc
4721: FROM
4722: pn_var_deductions_all dedc
4723: WHERE
4724: dedc.period_id = p_prd_id AND
4725: dedc.line_item_id = p_line_id AND
4726: dedc.grp_date_id = p_grp_id;

Line 4739: pn_var_deductions_all dedc

4735: dedc.deduction_amount
4736: ,dedc.start_date
4737: ,dedc.end_date
4738: FROM
4739: pn_var_deductions_all dedc
4740: WHERE
4741: dedc.period_id = p_prd_id AND
4742: dedc.line_item_id = p_line_id AND
4743: dedc.grp_date_id = p_grp_id AND