DBA Data[Home] [Help]

APPS.PAY_SE_WAGES_SALARIES dependencies on PAY_INPUT_VALUES_F

Line 431: ,pay_input_values_f iv1

427: ,per_all_assignments_f asg2
428: ,per_all_people_f per
429: ,pay_element_links_f el
430: ,pay_element_types_f et
431: ,pay_input_values_f iv1
432: ,pay_input_values_f iv2
433: ,pay_element_entries_f ee
434: ,pay_element_entry_values_f eev1
435: ,pay_element_entry_values_f eev2

Line 432: ,pay_input_values_f iv2

428: ,per_all_people_f per
429: ,pay_element_links_f el
430: ,pay_element_types_f et
431: ,pay_input_values_f iv1
432: ,pay_input_values_f iv2
433: ,pay_element_entries_f ee
434: ,pay_element_entry_values_f eev1
435: ,pay_element_entry_values_f eev2
436: WHERE asg1.assignment_id = csr_v_assignment_id

Line 969: ,pay_input_values_f iv1

965: ,per_all_assignments_f asg2
966: ,per_all_people_f per
967: ,pay_element_links_f el
968: ,pay_element_types_f et
969: ,pay_input_values_f iv1
970: ,pay_input_values_f iv2
971: ,pay_element_entries_f ee
972: ,pay_element_entry_values_f eev1
973: ,pay_element_entry_values_f eev2

Line 970: ,pay_input_values_f iv2

966: ,per_all_people_f per
967: ,pay_element_links_f el
968: ,pay_element_types_f et
969: ,pay_input_values_f iv1
970: ,pay_input_values_f iv2
971: ,pay_element_entries_f ee
972: ,pay_element_entry_values_f eev1
973: ,pay_element_entry_values_f eev2
974: WHERE asg1.assignment_id = csr_v_assignment_id

Line 1069: pay_input_values_f pivf,

1065: FROM pay_assignment_actions paa,
1066: pay_payroll_actions ppa,
1067: pay_run_results prr,
1068: pay_run_result_values prrv1,
1069: pay_input_values_f pivf,
1070: pay_element_types_f petf
1071: /* pay_run_result_values prrv2,
1072: pay_run_result_values prrv3*/
1073: WHERE ppa.effective_date BETWEEN csr_v_start_date --'01-feb-2000' --p_group_start_date --'01-jun-1999' --p_report_start_date

Line 1251: l_input_value_id pay_input_values_f.input_value_id%TYPE;

1247: l_valid_person number;
1248: l_check_insert number;
1249:
1250: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1251: l_input_value_id pay_input_values_f.input_value_id%TYPE;
1252: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
1253: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;
1254: l_period per_time_period_types.period_type%TYPE;
1255: l_period_start per_time_periods.start_date%TYPE;