DBA Data[Home] [Help]

APPS.BEN_TCS_COMPENSATION dependencies on PER_ALL_ASSIGNMENTS_F

Line 57: per_all_assignments_f asg

53: pay_basis,
54: PAY_ANNUALIZATION_FACTOR,
55: name
56: from per_pay_bases pay,
57: per_all_assignments_f asg
58: where pay.input_value_id = p_input_value_id
59: and pay.business_group_id = asg.business_group_id
60: and pay.pay_basis_id = asg.pay_basis_id
61: and asg.assignment_id = p_assignment_id

Line 594: FROM per_all_assignments_f paaf,

590: ,piv.element_type_id
591: ,prrv.input_value_id
592: ,prr.run_result_id
593: ,pet.output_currency_code
594: FROM per_all_assignments_f paaf,
595: pay_run_results prr,
596: Pay_run_result_values prrv,
597: pay_assignment_actions paa,
598: pay_payroll_actions ppa,

Line 650: Select * from per_all_assignments_f

646: p_salary_basis_id out nocopy number
647: ) is
648:
649: cursor csr_assignment_details is
650: Select * from per_all_assignments_f
651: where person_id = p_person_id
652: and p_effective_date between effective_start_date and effective_end_date
653: and assignment_id = p_assignment_id ;
654:

Line 822: from per_all_assignments_f asg,

818: asg.effective_start_date,
819: asg.effective_end_date,
820: number_per_fiscal_year,
821: status.pay_system_status
822: from per_all_assignments_f asg,
823: pay_payrolls_f pay ,per_time_period_types period,PER_ASSIGNMENT_STATUS_TYPES status
824: where assignment_id = p_assignment_id
825: --vkodedal = is added to fix payroll period issue 07-Sep-07
826: and asg.effective_start_date <= p_perd_en_dt