eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

Line 1501: from per_all_assignments_f paf, pay_payroll_actions ppa

1497: return varchar2 is
1498:
1499: cursor get_assign_info (p_assignment_id number, p_payroll_action_id number) is
1500: select paf.person_id, paf.location_id, paf.organization_id, paf.business_group_id
1501: from per_all_assignments_f paf, pay_payroll_actions ppa
1502: where paf.assignment_id = p_assignment_id
1503: and ppa.payroll_action_id = p_payroll_action_id
1504: and (ppa.effective_date between paf.effective_start_date and paf.effective_end_date);
1505: