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.PQP_PENSION_FUNCTIONS dependencies on PAY_PAYROLL_ACTIONS

Line 1882: ,pay_payroll_actions ppa

1878:
1879: CURSOR c_ass_act IS
1880: SELECT max(paa.assignment_action_id)
1881: FROM pay_assignment_actions paa
1882: ,pay_payroll_actions ppa
1883: WHERE paa.assignment_id = p_assignment_id
1884: AND ppa.action_status = 'C'
1885: AND ppa.action_type IN ('Q','R')
1886: AND paa.action_status = 'C'

Line 1998: ,p_payroll_id in pay_payroll_actions.payroll_id%TYPE

1994: function get_abp_pension_salary
1995: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
1996: ,p_date_earned in date
1997: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1998: ,p_payroll_id in pay_payroll_actions.payroll_id%TYPE
1999: ,p_period_start_date in date
2000: ,p_period_end_date in date
2001: ,p_scale_salary in number
2002: ,p_scale_salary_h in number

Line 3036: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE

3032: function get_pension_salary
3033: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
3034: ,p_date_earned in date
3035: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3036: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
3037: ,p_salary_balance_name in varchar2
3038: ,p_payroll_period in varchar2
3039: ,p_salary_balance_value out nocopy number
3040: ,p_error_message out nocopy varchar2

Line 3110: FROM pay_payroll_actions ppa

3106: --,c_payroll_id IN NUMBER
3107: ,c_period_start IN DATE
3108: ,c_period_end IN DATE) IS
3109: SELECT paa.assignment_action_id
3110: FROM pay_payroll_actions ppa
3111: ,pay_assignment_actions paa
3112: where ppa.payroll_action_id = paa.payroll_action_id
3113: and ppa.time_period_id = c_time_period_id
3114: --and payroll_id = c_payroll_id

Line 4505: FROM pay_payroll_actions ppa

4501: CURSOR c_get_asg_act_id (c_time_period_id IN NUMBER
4502: ,c_period_start IN DATE
4503: ,c_period_end IN DATE) IS
4504: SELECT paa.assignment_action_id
4505: FROM pay_payroll_actions ppa
4506: ,pay_assignment_actions paa
4507: WHERE ppa.payroll_action_id = paa.payroll_action_id
4508: AND ppa.time_period_id = c_time_period_id
4509: AND paa.assignment_id = p_assignment_id