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_NL_PENSION_EXTRACTS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 186: FROM pay_assignment_actions paa

182: SELECT paa.assignment_action_id
183: ,ppa.effective_date
184: ,ppa.action_type
185: ,ppa.date_earned
186: FROM pay_assignment_actions paa
187: ,pay_payroll_actions ppa
188: WHERE paa.assignment_id = c_assignment_id
189: AND ppa.action_status = 'C'
190: AND paa.action_status = 'C'

Line 212: FROM pay_assignment_actions paa

208: ,c_start_date IN Date
209: ,c_end_date IN Date
210: ) IS
211: SELECT max(paa.assignment_action_id)
212: FROM pay_assignment_actions paa
213: ,pay_payroll_actions ppa
214: WHERE paa.assignment_id = c_assignment_id
215: AND ppa.action_status = 'C'
216: AND ppa.action_type IN ('Q','R')

Line 235: FROM pay_assignment_actions paa

231: ,c_bg_id IN NUMBER
232:
233: ) IS
234: SELECT max(paa.assignment_action_id)
235: FROM pay_assignment_actions paa
236: ,pay_payroll_actions ppa
237: WHERE paa.assignment_id = c_assignment_id
238: AND ppa.action_status = 'C'
239: AND ppa.action_type IN ('Q','R')

Line 938: pay_assignment_actions paa

934: ,c_element_type_id in number) IS
935: SELECT element_entry_id
936: FROM pay_run_results prr,
937: pay_payroll_actions ppa,
938: pay_assignment_actions paa
939: WHERE paa.assignment_action_id = prr.assignment_action_id
940: AND paa.payroll_action_id = ppa.payroll_action_id
941: AND ppa.date_earned BETWEEN c_start_date
942: AND c_end_date

Line 1001: pay_assignment_actions paa

997: AND element_entry_id IN
998: (SELECT element_entry_id
999: FROM pay_run_results prr,
1000: pay_payroll_actions ppa,
1001: pay_assignment_actions paa
1002: WHERE paa.assignment_action_id = prr.assignment_action_id
1003: AND paa.payroll_action_id = ppa.payroll_action_id
1004: AND ppa.date_earned BETWEEN c_start_date
1005: AND c_end_date

Line 1141: pay_assignment_actions paa,

1137: pay_element_links_f pelf,
1138: pay_element_entry_values_f peev,
1139: pay_run_results prr,
1140: pay_run_result_values prrv,
1141: pay_assignment_actions paa,
1142: pay_payroll_actions ppa
1143: WHERE ppa.date_earned BETWEEN peef.effective_start_date AND
1144: peef.effective_end_date
1145: AND ppa.date_earned BETWEEN pelf.effective_start_date AND

Line 5835: FROM pay_assignment_actions paa

5831: -- 9917330
5832: CURSOR c_is_payroll_run(p_asg_id NUMBER, p_bg_id NUMBER, p_payroll_id number, p_cons_id number)
5833: IS
5834: SELECT 1
5835: FROM pay_assignment_actions paa
5836: ,pay_payroll_actions ppa
5837: WHERE paa.assignment_id = p_asg_id
5838: AND ppa.BUSINESS_GROUP_ID = p_bg_id
5839: AND ppa.action_status = 'C'

Line 7636: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

7632: AND TRUNC(NVL(fnd_date.canonical_to_date(aei_information2),hr_api.g_eot))
7633: AND aei_information6 IS NOT NULL;
7634:
7635: l_ret_val NUMBER := 0;
7636: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
7637: l_bal_exists NUMBER;
7638: l_balance_id pay_balance_types.balance_type_id%TYPE;
7639: l_balance_amount NUMBER := 0;
7640: l_override_value ben_ext_chg_evt_log.new_val1%TYPE;

Line 8928: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

8924: l_new_hire NUMBER := 0;
8925: l_balance_amount NUMBER := 0;
8926: l_override_value NUMBER := 0;
8927: l_person_id per_all_people_f.person_id%TYPE;
8928: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
8929: l_balance_id pay_balance_types.balance_type_id%TYPE;
8930: l_proc_name VARCHAR2(150) := g_proc_name ||'Record08_Display_Criteria';
8931: l_hire_dt DATE;
8932: l_08_sent NUMBER;

Line 9404: pay_assignment_actions paa,

9400: CURSOR c_run_results_exist IS
9401: SELECT pty.pension_type_id
9402: FROM pay_run_results prr,
9403: pay_payroll_actions ppa,
9404: pay_assignment_actions paa,
9405: pay_element_type_extra_info pei,
9406: pqp_pension_types_f pty
9407: WHERE paa.assignment_action_id = prr.assignment_action_id
9408: AND paa.payroll_action_id = ppa.payroll_action_id

Line 9930: pay_assignment_actions paa,

9926: CURSOR c_run_results_exist IS
9927: SELECT pty.pension_type_id
9928: FROM pay_run_results prr,
9929: pay_payroll_actions ppa,
9930: pay_assignment_actions paa,
9931: pay_element_type_extra_info pei,
9932: pqp_pension_types_f pty
9933: WHERE paa.assignment_action_id = prr.assignment_action_id
9934: AND paa.payroll_action_id = ppa.payroll_action_id

Line 10273: pay_assignment_actions paa,

10269: CURSOR c_rr_cur IS
10270: SELECT 1
10271: FROM pay_run_results prr,
10272: pay_payroll_actions ppa,
10273: pay_assignment_actions paa,
10274: pay_element_type_extra_info pei,
10275: pqp_pension_types_f pty
10276: WHERE paa.assignment_action_id = prr.assignment_action_id
10277: AND paa.payroll_action_id = ppa.payroll_action_id

Line 10416: pay_assignment_actions paa,

10412: ,'FPU_S','S'
10413: ,'FPU_T' ,'B') fpu_code
10414: FROM pay_run_results prr,
10415: pay_payroll_actions ppa,
10416: pay_assignment_actions paa,
10417: pay_element_type_extra_info pei,
10418: pqp_pension_types_f pty
10419: WHERE paa.assignment_action_id = prr.assignment_action_id
10420: AND paa.payroll_action_id = ppa.payroll_action_id

Line 11019: pay_assignment_actions paa,

11015: SELECT pty.pension_type_id
11016: ,pty.pension_sub_category sub_cat
11017: FROM pay_run_results prr,
11018: pay_payroll_actions ppa,
11019: pay_assignment_actions paa,
11020: pay_element_type_extra_info pei,
11021: pqp_pension_types_f pty
11022: WHERE paa.assignment_action_id = prr.assignment_action_id
11023: AND paa.payroll_action_id = ppa.payroll_action_id

Line 12320: pay_assignment_actions paa,

12316: CURSOR c_run_results_exist IS
12317: SELECT pty.pension_type_id
12318: FROM pay_run_results prr,
12319: pay_payroll_actions ppa,
12320: pay_assignment_actions paa,
12321: pay_element_type_extra_info pei,
12322: pqp_pension_types_f pty
12323: WHERE paa.assignment_action_id = prr.assignment_action_id
12324: AND paa.payroll_action_id = ppa.payroll_action_id

Line 12881: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

12877: l_main_rec csr_rslt_dtl%ROWTYPE;
12878: l_new_rec csr_rslt_dtl%ROWTYPE;
12879: l_old_date_can ben_ext_chg_evt_log.old_val1%TYPE;
12880: l_new_date_can ben_ext_chg_evt_log.new_val1%TYPE;
12881: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
12882: l_pension_sal_char VARCHAR2(15);
12883: l_pension_yr_char VARCHAR2(15);
12884: l_get_ps_val NUMBER;
12885: l_get_yr_val NUMBER;

Line 12956: pay_assignment_actions paa

12952:
12953: SELECT date_earned
12954: INTO l_max_de
12955: FROM pay_payroll_actions ppa,
12956: pay_assignment_actions paa
12957: WHERE ppa.payroll_action_id = paa.payroll_action_id
12958: AND paa.assignment_action_id =l_de_asg_act;
12959: --
12960: -- Derive the pension salary

Line 13206: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

13202: ,p_data_element_value OUT NOCOPY Varchar2
13203: ) RETURN Number IS
13204:
13205: l_ret_val Number := 0;
13206: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
13207: l_proc_name Varchar2(150) := g_proc_name ||'Process_Mult_Rec09';
13208: l_rcd_id Number;
13209: l_index Number;
13210: l_main_rec csr_rslt_dtl%ROWTYPE;

Line 13276: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

13272: ,p_data_element_value OUT NOCOPY Varchar2
13273: ) RETURN Number IS
13274:
13275: l_ret_val Number := 0;
13276: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
13277: l_proc_name Varchar2(150) := g_proc_name ||'Process_Mult_Rec12';
13278: l_rcd_id Number;
13279: l_index Number;
13280: i Number;

Line 13483: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

13479: ,p_data_element_value OUT NOCOPY Varchar2
13480: ) RETURN Number IS
13481:
13482: l_ret_val Number := 0;
13483: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
13484: l_proc_name Varchar2(150) := g_proc_name ||'Process_Mult_Rec31';
13485: l_rcd_id Number;
13486: l_index Number;
13487: l_main_rec csr_rslt_dtl%ROWTYPE;

Line 13617: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

13613: ,p_data_element_value OUT NOCOPY Varchar2
13614: ) RETURN Number IS
13615:
13616: l_ret_val Number := 0;
13617: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
13618: l_proc_name Varchar2(150) := g_proc_name ||'Process_Mult_Rec41';
13619: l_rcd_id Number;
13620: l_index Number;
13621: l_main_rec csr_rslt_dtl%ROWTYPE;

Line 13725: FROM pay_payroll_actions ppa,pay_assignment_actions paa

13721: --cursor to check if run results exist for any FUR Pension Types for this assignment
13722: --in this period
13723: CURSOR c_run_results_exist IS
13724: SELECT paa.assignment_action_id
13725: FROM pay_payroll_actions ppa,pay_assignment_actions paa
13726: WHERE paa.payroll_action_id = ppa.payroll_action_id
13727: AND ppa.date_earned BETWEEN g_extract_params(p_business_group_id).extract_start_date
13728: AND g_extract_params(p_business_group_id).extract_end_date
13729: AND paa.assignment_id = p_assignment_id

Line 13818: pay_assignment_actions paa,

13814: SELECT prr.assignment_action_id,
13815: pei.eei_information9
13816: FROM pay_run_results prr,
13817: pay_payroll_actions ppa,
13818: pay_assignment_actions paa,
13819: pay_element_type_extra_info pei,
13820: pqp_pension_types_f pty
13821: WHERE paa.assignment_action_id = prr.assignment_action_id
13822: AND paa.payroll_action_id = ppa.payroll_action_id

Line 14108: FROM pay_payroll_actions ppa,pay_assignment_actions paa

14104: --cursor to check if run results exist for any IPAP Pension Types for this assignment
14105: --in this period
14106: CURSOR c_run_results_exist IS
14107: SELECT paa.assignment_action_id
14108: FROM pay_payroll_actions ppa,pay_assignment_actions paa
14109: WHERE paa.payroll_action_id = ppa.payroll_action_id
14110: AND ppa.date_earned BETWEEN g_extract_params(p_business_group_id).extract_start_date
14111: AND g_extract_params(p_business_group_id).extract_end_date
14112: AND paa.assignment_id = p_assignment_id