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 513: FROM per_all_assignments_f paaf,

509: ,pec.costing_debit_or_credit
510: ,pc.costed_value
511: ,petf.output_currency_code
512: ,pc.cost_id
513: FROM per_all_assignments_f paaf,
514: pay_assignment_actions paa,
515: pay_assignment_actions paa2,
516: pay_payroll_actions ppa,
517: pay_payroll_actions ppa2,

Line 585: Select * from per_all_assignments_f

581: p_salary_basis_id out nocopy number
582: ) is
583:
584: cursor csr_assignment_details is
585: Select * from per_all_assignments_f
586: where person_id = p_person_id
587: and p_effective_date between effective_start_date and effective_end_date
588: and assignment_id = p_assignment_id ;
589:

Line 755: from per_all_assignments_f asg,

751: cursor csr_asg_payroll is
752: select distinct asg.payroll_id,
753: asg.effective_start_date,
754: asg.effective_end_date,number_per_fiscal_year
755: from per_all_assignments_f asg,
756: pay_payrolls_f pay ,per_time_period_types period,PER_ASSIGNMENT_STATUS_TYPES status
757: where assignment_id = p_assignment_id
758: --vkodedal = is added to fix payroll period issue 07-Sep-07
759: and asg.effective_start_date <= p_perd_en_dt