DBA Data[Home] [Help]

APPS.PAY_DK_GENERAL dependencies on FND_NUMBER

Line 554: SELECT fnd_number.canonical_to_number(NVL(peevf.screen_entry_value,'0')) Employee_Amount,

550: AND p_effective_date BETWEEN peef.effective_start_date AND peef.effective_end_date;
551:
552: CURSOR c_input_values(p_element_entry_id IN NUMBER)
553: IS
554: SELECT fnd_number.canonical_to_number(NVL(peevf.screen_entry_value,'0')) Employee_Amount,
555: fnd_number.canonical_to_number(NVL(peevf1.screen_entry_value,'0')) Employer_Amount,
556: fnd_number.canonical_to_number(NVL(peevf2.screen_entry_value,'0')) Employee_Percent,
557: fnd_number.canonical_to_number(NVL(peevf3.screen_entry_value,'0')) Employer_Percent
558: from

Line 555: fnd_number.canonical_to_number(NVL(peevf1.screen_entry_value,'0')) Employer_Amount,

551:
552: CURSOR c_input_values(p_element_entry_id IN NUMBER)
553: IS
554: SELECT fnd_number.canonical_to_number(NVL(peevf.screen_entry_value,'0')) Employee_Amount,
555: fnd_number.canonical_to_number(NVL(peevf1.screen_entry_value,'0')) Employer_Amount,
556: fnd_number.canonical_to_number(NVL(peevf2.screen_entry_value,'0')) Employee_Percent,
557: fnd_number.canonical_to_number(NVL(peevf3.screen_entry_value,'0')) Employer_Percent
558: from
559: pay_element_entry_values_f peevf,

Line 556: fnd_number.canonical_to_number(NVL(peevf2.screen_entry_value,'0')) Employee_Percent,

552: CURSOR c_input_values(p_element_entry_id IN NUMBER)
553: IS
554: SELECT fnd_number.canonical_to_number(NVL(peevf.screen_entry_value,'0')) Employee_Amount,
555: fnd_number.canonical_to_number(NVL(peevf1.screen_entry_value,'0')) Employer_Amount,
556: fnd_number.canonical_to_number(NVL(peevf2.screen_entry_value,'0')) Employee_Percent,
557: fnd_number.canonical_to_number(NVL(peevf3.screen_entry_value,'0')) Employer_Percent
558: from
559: pay_element_entry_values_f peevf,
560: pay_element_entry_values_f peevf1,

Line 557: fnd_number.canonical_to_number(NVL(peevf3.screen_entry_value,'0')) Employer_Percent

553: IS
554: SELECT fnd_number.canonical_to_number(NVL(peevf.screen_entry_value,'0')) Employee_Amount,
555: fnd_number.canonical_to_number(NVL(peevf1.screen_entry_value,'0')) Employer_Amount,
556: fnd_number.canonical_to_number(NVL(peevf2.screen_entry_value,'0')) Employee_Percent,
557: fnd_number.canonical_to_number(NVL(peevf3.screen_entry_value,'0')) Employer_Percent
558: from
559: pay_element_entry_values_f peevf,
560: pay_element_entry_values_f peevf1,
561: pay_element_entry_values_f peevf2,