DBA Data[Home] [Help]

APPS.CN_PAY_ELEMENT_INPUTS_PVT dependencies on PAY_INPUT_VALUES_F

Line 207: pay_input_values_f piv,

203: -- Check for Element input exist in Payroll
204: --
205: SELECT count(*) INTO l_count
206: FROM
207: pay_input_values_f piv,
208: pay_element_types_f pet,
209: cn_quota_pay_elements cqpe,
210: gl_sets_of_books glsob,
211: cn_repositories cnr

Line 780: l_pay_input_name pay_input_values_f.name%TYPE;

776: l_element_type_id cn_pay_element_inputs.element_type_id%TYPE;
777: l_table_name cn_objects_all.name%TYPE;
778: l_column_name cn_objects_all.name%TYPE;
779: l_pay_element_name pay_element_types.element_name%TYPE;
780: l_pay_input_name pay_input_values_f.name%TYPE;
781: l_line_number cn_pay_element_inputs.line_number%TYPE;
782: l_quota_pay_element_id cn_pay_element_inputs.quota_pay_element_id%TYPE;
783:
784:

Line 795: pay_input_values_f piv,

791: piv.display_sequence line_number,
792: cpei.quota_pay_element_id quota_pay_element_id
793: FROM cn_pay_element_inputs cpei,
794: cn_quota_pay_elements cqpe,
795: pay_input_values_f piv,
796: pay_element_types_f pet,
797: cn_objects ct,
798: cn_objects cc,
799: gl_sets_of_books glsob,

Line 826: pay_input_values_f piv,

822: piv.name pay_value_name,
823: piv.display_sequence line_number,
824: 0 quota_pay_element_id
825: FROM
826: pay_input_values_f piv,
827: pay_element_types_f pet,
828: cn_quota_pay_elements cqpe,
829: gl_sets_of_books glsob,
830: cn_repositories cnr