DBA Data[Home] [Help]

APPS.PAY_AU_SOE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 243: (p_assignment_id in per_all_assignments_f.assignment_id%type,

239: -- Procedure to merely pass all the balance results back in one hit,
240: -- rather than 6 separate calls.
241: ------------------------------------------------------------------------
242: procedure balance_totals
243: (p_assignment_id in per_all_assignments_f.assignment_id%type,
244: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
245: p_effective_date in date,
246: p_gross_this_pay out NOCOPY number,
247: p_other_deductions_this_pay out NOCOPY number,

Line 716: (p_assignment_id in per_all_assignments_f.assignment_id%type,

712: /* bug 3935483 2 new parameters added in balance_totals and final_balance_totals , p_get_le_level_bal to fetch le level balances when it is Y and
713: p_fetch_only_ytd_value to fetch only ytd balances and not run balances */
714:
715: procedure final_balance_totals
716: (p_assignment_id in per_all_assignments_f.assignment_id%type,
717: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
718: p_effective_date in date,
719: p_gross_this_pay out NOCOPY number,
720: p_other_deductions_this_pay out NOCOPY number,

Line 865: p_assignment_id in per_all_assignments_f.assignment_id%type,

861: (p_source_id in number,
862: p_element_reporting_name in pay_element_types_f.reporting_name%type,
863: p_date_earned in pay_payroll_actions.date_earned%type,
864: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
865: p_assignment_id in per_all_assignments_f.assignment_id%type,
866: p_element_entry_id in pay_element_entries_f.PERSONAL_PAYMENT_METHOD_ID%TYPE,
867: p_business_group_id per_all_assignments_f.business_group_id%TYPE)
868: return varchar2
869:

Line 867: p_business_group_id per_all_assignments_f.business_group_id%TYPE)

863: p_date_earned in pay_payroll_actions.date_earned%type,
864: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
865: p_assignment_id in per_all_assignments_f.assignment_id%type,
866: p_element_entry_id in pay_element_entries_f.PERSONAL_PAYMENT_METHOD_ID%TYPE,
867: p_business_group_id per_all_assignments_f.business_group_id%TYPE)
868: return varchar2
869:
870: is
871:

Line 1131: p_pay_bases_id IN per_all_assignments_f.pay_basis_id%TYPE,

1127: FUNCTION get_element_payment_hours
1128: (
1129: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
1130: p_element_type_id IN pay_element_entries_f.element_entry_id%TYPE,
1131: p_pay_bases_id IN per_all_assignments_f.pay_basis_id%TYPE,
1132: p_run_result_id IN pay_run_results.run_result_ID%TYPE,
1133: p_effective_date IN pay_payroll_actions.effective_date%TYPE
1134: )
1135: RETURN NUMBER