DBA Data[Home] [Help]

APPS.PAY_IN_SOE dependencies on PAY_APAC_PAYSLIP_ELEMENTS_V

Line 547: FROM pay_apac_payslip_elements_v

543: ,'Earnings', element_reporting_name
544: ,'Paid Monetary Perquisite', SUBSTR(element_reporting_name, 0,
545: LENGTH(element_reporting_name) - 8)) ename
546: ,current_amount amt
547: FROM pay_apac_payslip_elements_v
548: WHERE action_context_id = p_action_context_id
549: AND (element_classification = p_classification_name
550: OR element_classification = 'Paid Monetary Perquisite');
551:

Line 557: FROM pay_apac_payslip_elements_v

553: IS
554: --
555: SELECT element_reporting_name ename
556: ,current_amount amt
557: FROM pay_apac_payslip_elements_v
558: WHERE action_context_id = p_action_context_id
559: AND element_classification = p_classification_name;
560:
561: l_total NUMBER;

Line 702: FROM pay_apac_payslip_elements_v

698: CURSOR csr_sum_amt(p_classification_name VARCHAR2)
699: IS
700: --
701: SELECT sum(current_amount) amt
702: FROM pay_apac_payslip_elements_v
703: WHERE action_context_id = p_action_context_id
704: AND element_classification = p_classification_name;
705:
706: l_gross_earnings NUMBER;