DBA Data[Home] [Help]

APPS.HXT_BATCH_PROCESS dependencies on PAY_INPUT_VALUES_F

Line 980: (sequence PAY_INPUT_VALUES_F.INPUT_VALUE_ID%TYPE,

976: l_value_meaning hr_lookups.meaning%TYPE;
977: l_return NUMBER;
978: l_line_ovn number;
979: TYPE input_value_record IS RECORD
980: (sequence PAY_INPUT_VALUES_F.INPUT_VALUE_ID%TYPE,
981: name PAY_INPUT_VALUES_F_TL.NAME%TYPE, --FORMS60
982: lookup PAY_INPUT_VALUES_F.LOOKUP_TYPE%TYPE);
983: TYPE input_values_table IS TABLE OF input_value_record
984: INDEX BY BINARY_INTEGER;

Line 981: name PAY_INPUT_VALUES_F_TL.NAME%TYPE, --FORMS60

977: l_return NUMBER;
978: l_line_ovn number;
979: TYPE input_value_record IS RECORD
980: (sequence PAY_INPUT_VALUES_F.INPUT_VALUE_ID%TYPE,
981: name PAY_INPUT_VALUES_F_TL.NAME%TYPE, --FORMS60
982: lookup PAY_INPUT_VALUES_F.LOOKUP_TYPE%TYPE);
983: TYPE input_values_table IS TABLE OF input_value_record
984: INDEX BY BINARY_INTEGER;
985: hxt_value input_values_table;

Line 982: lookup PAY_INPUT_VALUES_F.LOOKUP_TYPE%TYPE);

978: l_line_ovn number;
979: TYPE input_value_record IS RECORD
980: (sequence PAY_INPUT_VALUES_F.INPUT_VALUE_ID%TYPE,
981: name PAY_INPUT_VALUES_F_TL.NAME%TYPE, --FORMS60
982: lookup PAY_INPUT_VALUES_F.LOOKUP_TYPE%TYPE);
983: TYPE input_values_table IS TABLE OF input_value_record
984: INDEX BY BINARY_INTEGER;
985: hxt_value input_values_table;
986: TYPE pbl_values_table IS TABLE OF PAY_BATCH_LINES.VALUE_1%TYPE

Line 994: pay_input_values_f PIV

990: ,cp_assignment_id NUMBER
991: ,cp_effective_date DATE) IS
992: SELECT distinct PIV.name -- PIV.display_sequence
993: FROM --pay_element_types_f PET
994: pay_input_values_f PIV
995: ,pay_accrual_plans PAP
996: ,pay_net_calculation_rules PNCR
997: WHERE--PET.element_type_id = cp_element_type_id
998: --AND PET.element_type_id = PIV.element_type_id