DBA Data[Home] [Help]

APPS.PAY_SG_SOE dependencies on PER_ALL_PEOPLE_F

Line 106: p_person_id in per_all_people_f.person_id%type,

102: procedure current_and_ytd_balances
103: (p_prepaid_tag in varchar,
104: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
105: p_balance_name in pay_balance_types.balance_name%type,
106: p_person_id in per_all_people_f.person_id%type,
107: p_current_balance out nocopy number,
108: p_ytd_balance out nocopy number)
109: is
110: v_balance_value number;

Line 182: (c_person_id per_all_people_f.person_id%type,

178:
179: /* Bug #2824397 */
180: /* Bug:2824397 Added extra parameter c_date_earned */
181: cursor c_check_assignment
182: (c_person_id per_all_people_f.person_id%type,
183: c_date_earned pay_payroll_actions.date_earned%type) is
184: select distinct assignment_id
185: from per_all_assignments_f
186: where person_id = c_person_id

Line 341: p_person_id in per_all_people_f.person_id%type,

337:
338: procedure current_and_ytd_balances
339: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
340: p_balance_name in pay_balance_types.balance_name%type,
341: p_person_id in per_all_people_f.person_id%type,
342: p_current_balance out nocopy number,
343: p_ytd_balance out nocopy number)
344: is
345: v_balance_value number;

Line 413: (c_person_id per_all_people_f.person_id%type,

409:
410: /* Bug #2824397 */
411: /* Bug:2824397 Added extra parameter c_date_earned */
412: cursor c_check_assignment
413: (c_person_id per_all_people_f.person_id%type,
414: c_date_earned pay_payroll_actions.date_earned%type ) is
415: select distinct assignment_id
416: from per_all_assignments_f
417: where person_id = c_person_id

Line 560: p_person_id in per_all_people_f.person_id%type,

556: ------------------------------------------------------------------------
557: procedure balance_totals
558: (p_prepaid_tag in varchar,
559: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
560: p_person_id in per_all_people_f.person_id%type,
561: p_gross_pay_current out nocopy number,
562: p_statutory_deductions_current out nocopy number,
563: p_other_deductions_current out nocopy number,
564: p_net_pay_current out nocopy number,

Line 713: p_person_id in per_all_people_f.person_id%type,

709: -- for the Pay Advice report
710: ------------------------------------------------------------------------
711: procedure balance_totals
712: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
713: p_person_id in per_all_people_f.person_id%type,
714: p_gross_pay_current out nocopy number,
715: p_statutory_deductions_current out nocopy number,
716: p_other_deductions_current out nocopy number,
717: p_net_pay_current out nocopy number,