APPS.PSP_ENC_CREATE_LINES dependencies on PAY_INPUT_VALUES_F

Line 645: pay_input_values_f piv,

641: DECODE(psp_general.business_days(MAX(ptp.start_date), MAX(ptp.end_date),p_assignment_id), 0, 1,
642: psp_general.business_days(MAX(ptp.start_date), MAX(ptp.end_date),p_assignment_id)) ) period_amount,
643: ptp.time_period_id
644: FROM pay_element_entry_values_f peev,
645: pay_input_values_f piv,
646: pay_element_entries_f pee,
647: pay_element_links_f pel,
648: pay_element_types_f pet,
649: psp_enc_elements peel,

Line 705: pay_input_values_f piv,

701: ppb.pay_annualization_factor,
702: paf.effective_start_date,
703: paf.effective_end_date
704: FROM per_pay_proposals ppp,
705: pay_input_values_f piv,
706: per_pay_bases ppb,
707: per_all_assignments_f paf,
708: per_assignment_status_types past
709: WHERE paf.assignment_id =p_assignment_id

Line 750: pay_input_values_f piv,

746: SELECT DISTINCT GREATEST(paf.effective_start_date, peev.effective_start_date) element_start_date,
747: LEAST(paf.effective_end_date, peev.effective_end_date) element_end_date,
748: fnd_number.canonical_to_number(NVL(peev.screen_entry_value, 0)) pay_amount
749: FROM pay_element_entry_values_f peev,
750: pay_input_values_f piv,
751: pay_element_entries_f pee,
752: pay_element_links_f pel,
753: pay_element_types_f pet,
754: psp_enc_elements peel,

Line 799: FROM pay_input_values_f piv

795: FROM psp_enc_elements pee
796: WHERE element_type_id = p_element_type_id
797: AND ( formula_id IS NOT NULL
798: OR EXISTS (SELECT 1
799: FROM pay_input_values_f piv
800: WHERE piv.input_value_id = pee.input_value_id
801: AND SUBSTR(piv.uom, 1, 1) = g_uom));
802:
803: l_num_per_fiscal_year NUMBER;

Line 6754: FROM pay_input_values_f piv

6750: FROM psp_enc_elements pee
6751: WHERE element_type_id = p_element_type_id
6752: AND ( formula_id IS NOT NULL
6753: OR EXISTS (SELECT 1
6754: FROM pay_input_values_f piv
6755: WHERE piv.input_value_id = pee.input_value_id
6756: AND SUBSTR(piv.uom, 1, 1) <> 'H'));
6757:
6758: CURSOR hours_value_cur (p_element_type_id IN NUMBER) IS

Line 6764: FROM pay_input_values_f piv

6760: FROM psp_enc_elements pee
6761: WHERE element_type_id = p_element_type_id
6762: AND ( formula_id IS NOT NULL
6763: OR EXISTS (SELECT 1
6764: FROM pay_input_values_f piv
6765: WHERE piv.input_value_id = pee.input_value_id
6766: AND SUBSTR(piv.uom, 1, 1) = 'H'));
6767:
6768: