APPS.PSP_ENC_CREATE_LINES dependencies on PAY_INPUT_VALUES_F

Line 847: pay_input_values_f piv,

843: DECODE(psp_general.business_days(MAX(ptp.start_date), MAX(ptp.end_date),p_assignment_id), 0, 1,
844: psp_general.business_days(MAX(ptp.start_date), MAX(ptp.end_date),p_assignment_id)) ) period_amount,
845: ptp.time_period_id
846: FROM pay_element_entry_values_f peev,
847: pay_input_values_f piv,
848: pay_element_entries_f pee,
849: pay_element_links_f pel,
850: pay_element_types_f pet,
851: psp_enc_elements peel,

Line 907: pay_input_values_f piv,

903: ppb.pay_annualization_factor,
904: paf.effective_start_date,
905: paf.effective_end_date
906: FROM per_pay_proposals ppp,
907: pay_input_values_f piv,
908: per_pay_bases ppb,
909: per_all_assignments_f paf,
910: per_assignment_status_types past
911: WHERE paf.assignment_id =p_assignment_id

Line 952: pay_input_values_f piv,

948: SELECT DISTINCT GREATEST(paf.effective_start_date, peev.effective_start_date) element_start_date,
949: LEAST(paf.effective_end_date, peev.effective_end_date) element_end_date,
950: fnd_number.canonical_to_number(NVL(peev.screen_entry_value, 0)) pay_amount
951: FROM pay_element_entry_values_f peev,
952: pay_input_values_f piv,
953: pay_element_entries_f pee,
954: pay_element_links_f pel,
955: pay_element_types_f pet,
956: psp_enc_elements peel,

Line 1002: FROM pay_input_values_f piv

998: FROM psp_enc_elements pee
999: WHERE element_type_id = p_element_type_id
1000: AND ( formula_id IS NOT NULL
1001: OR EXISTS (SELECT 1
1002: FROM pay_input_values_f piv
1003: WHERE piv.input_value_id = pee.input_value_id
1004: AND SUBSTR(piv.uom, 1, 1) = g_uom));
1005:
1006: l_num_per_fiscal_year NUMBER;

Line 7031: FROM pay_input_values_f piv

7027: FROM psp_enc_elements pee
7028: WHERE element_type_id = p_element_type_id
7029: AND ( formula_id IS NOT NULL
7030: OR EXISTS (SELECT 1
7031: FROM pay_input_values_f piv
7032: WHERE piv.input_value_id = pee.input_value_id
7033: AND SUBSTR(piv.uom, 1, 1) <> 'H'));
7034:
7035: CURSOR hours_value_cur (p_element_type_id IN NUMBER) IS

Line 7041: FROM pay_input_values_f piv

7037: FROM psp_enc_elements pee
7038: WHERE element_type_id = p_element_type_id
7039: AND ( formula_id IS NOT NULL
7040: OR EXISTS (SELECT 1
7041: FROM pay_input_values_f piv
7042: WHERE piv.input_value_id = pee.input_value_id
7043: AND SUBSTR(piv.uom, 1, 1) = 'H'));
7044:
7045: