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 919: pay_assignment_actions paa

915: ,c_element_type_id in number) IS
916: SELECT element_entry_id
917: FROM pay_run_results prr,
918: pay_payroll_actions ppa,
919: pay_assignment_actions paa
920: WHERE paa.assignment_action_id = prr.assignment_action_id
921: AND paa.payroll_action_id = ppa.payroll_action_id
922: AND ppa.date_earned BETWEEN c_start_date
923: AND c_end_date

Line 982: pay_assignment_actions paa

978: AND element_entry_id IN
979: (SELECT element_entry_id
980: FROM pay_run_results prr,
981: pay_payroll_actions ppa,
982: pay_assignment_actions paa
983: WHERE paa.assignment_action_id = prr.assignment_action_id
984: AND paa.payroll_action_id = ppa.payroll_action_id
985: AND ppa.date_earned BETWEEN c_start_date
986: AND c_end_date

Line 1122: pay_assignment_actions paa,

1118: pay_element_links_f pelf,
1119: pay_element_entry_values_f peev,
1120: pay_run_results prr,
1121: pay_run_result_values prrv,
1122: pay_assignment_actions paa,
1123: pay_payroll_actions ppa
1124: WHERE ppa.date_earned BETWEEN peef.effective_start_date AND
1125: peef.effective_end_date
1126: AND ppa.date_earned BETWEEN pelf.effective_start_date AND

Line 7297: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

7293: AND TRUNC(NVL(fnd_date.canonical_to_date(aei_information2),hr_api.g_eot))
7294: AND aei_information6 IS NOT NULL;
7295:
7296: l_ret_val NUMBER := 0;
7297: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
7298: l_bal_exists NUMBER;
7299: l_balance_id pay_balance_types.balance_type_id%TYPE;
7300: l_balance_amount NUMBER := 0;
7301: l_override_value ben_ext_chg_evt_log.new_val1%TYPE;

Line 8589: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

8585: l_new_hire NUMBER := 0;
8586: l_balance_amount NUMBER := 0;
8587: l_override_value NUMBER := 0;
8588: l_person_id per_all_people_f.person_id%TYPE;
8589: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
8590: l_balance_id pay_balance_types.balance_type_id%TYPE;
8591: l_proc_name VARCHAR2(150) := g_proc_name ||'Record08_Display_Criteria';
8592: l_hire_dt DATE;
8593: l_08_sent NUMBER;

Line 9065: pay_assignment_actions paa,

9061: CURSOR c_run_results_exist IS
9062: SELECT pty.pension_type_id
9063: FROM pay_run_results prr,
9064: pay_payroll_actions ppa,
9065: pay_assignment_actions paa,
9066: pay_element_type_extra_info pei,
9067: pqp_pension_types_f pty
9068: WHERE paa.assignment_action_id = prr.assignment_action_id
9069: AND paa.payroll_action_id = ppa.payroll_action_id

Line 9591: pay_assignment_actions paa,

9587: CURSOR c_run_results_exist IS
9588: SELECT pty.pension_type_id
9589: FROM pay_run_results prr,
9590: pay_payroll_actions ppa,
9591: pay_assignment_actions paa,
9592: pay_element_type_extra_info pei,
9593: pqp_pension_types_f pty
9594: WHERE paa.assignment_action_id = prr.assignment_action_id
9595: AND paa.payroll_action_id = ppa.payroll_action_id

Line 9934: pay_assignment_actions paa,

9930: CURSOR c_rr_cur IS
9931: SELECT 1
9932: FROM pay_run_results prr,
9933: pay_payroll_actions ppa,
9934: pay_assignment_actions paa,
9935: pay_element_type_extra_info pei,
9936: pqp_pension_types_f pty
9937: WHERE paa.assignment_action_id = prr.assignment_action_id
9938: AND paa.payroll_action_id = ppa.payroll_action_id

Line 10077: pay_assignment_actions paa,

10073: ,'FPU_S','S'
10074: ,'FPU_T' ,'B') fpu_code
10075: FROM pay_run_results prr,
10076: pay_payroll_actions ppa,
10077: pay_assignment_actions paa,
10078: pay_element_type_extra_info pei,
10079: pqp_pension_types_f pty
10080: WHERE paa.assignment_action_id = prr.assignment_action_id
10081: AND paa.payroll_action_id = ppa.payroll_action_id

Line 10680: pay_assignment_actions paa,

10676: SELECT pty.pension_type_id
10677: ,pty.pension_sub_category sub_cat
10678: FROM pay_run_results prr,
10679: pay_payroll_actions ppa,
10680: pay_assignment_actions paa,
10681: pay_element_type_extra_info pei,
10682: pqp_pension_types_f pty
10683: WHERE paa.assignment_action_id = prr.assignment_action_id
10684: AND paa.payroll_action_id = ppa.payroll_action_id

Line 11951: pay_assignment_actions paa,

11947: CURSOR c_run_results_exist IS
11948: SELECT pty.pension_type_id
11949: FROM pay_run_results prr,
11950: pay_payroll_actions ppa,
11951: pay_assignment_actions paa,
11952: pay_element_type_extra_info pei,
11953: pqp_pension_types_f pty
11954: WHERE paa.assignment_action_id = prr.assignment_action_id
11955: AND paa.payroll_action_id = ppa.payroll_action_id

Line 12512: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

12508: l_main_rec csr_rslt_dtl%ROWTYPE;
12509: l_new_rec csr_rslt_dtl%ROWTYPE;
12510: l_old_date_can ben_ext_chg_evt_log.old_val1%TYPE;
12511: l_new_date_can ben_ext_chg_evt_log.new_val1%TYPE;
12512: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
12513: l_pension_sal_char VARCHAR2(15);
12514: l_pension_yr_char VARCHAR2(15);
12515: l_get_ps_val NUMBER;
12516: l_get_yr_val NUMBER;

Line 12587: pay_assignment_actions paa

12583:
12584: SELECT date_earned
12585: INTO l_max_de
12586: FROM pay_payroll_actions ppa,
12587: pay_assignment_actions paa
12588: WHERE ppa.payroll_action_id = paa.payroll_action_id
12589: AND paa.assignment_action_id =l_de_asg_act;
12590: --
12591: -- Derive the pension salary

Line 12837: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

12833: ,p_data_element_value OUT NOCOPY Varchar2
12834: ) RETURN Number IS
12835:
12836: l_ret_val Number := 0;
12837: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
12838: l_proc_name Varchar2(150) := g_proc_name ||'Process_Mult_Rec09';
12839: l_rcd_id Number;
12840: l_index Number;
12841: l_main_rec csr_rslt_dtl%ROWTYPE;

Line 12907: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

12903: ,p_data_element_value OUT NOCOPY Varchar2
12904: ) RETURN Number IS
12905:
12906: l_ret_val Number := 0;
12907: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
12908: l_proc_name Varchar2(150) := g_proc_name ||'Process_Mult_Rec12';
12909: l_rcd_id Number;
12910: l_index Number;
12911: i Number;

Line 13114: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

13110: ,p_data_element_value OUT NOCOPY Varchar2
13111: ) RETURN Number IS
13112:
13113: l_ret_val Number := 0;
13114: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
13115: l_proc_name Varchar2(150) := g_proc_name ||'Process_Mult_Rec31';
13116: l_rcd_id Number;
13117: l_index Number;
13118: l_main_rec csr_rslt_dtl%ROWTYPE;

Line 13248: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

13244: ,p_data_element_value OUT NOCOPY Varchar2
13245: ) RETURN Number IS
13246:
13247: l_ret_val Number := 0;
13248: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
13249: l_proc_name Varchar2(150) := g_proc_name ||'Process_Mult_Rec41';
13250: l_rcd_id Number;
13251: l_index Number;
13252: l_main_rec csr_rslt_dtl%ROWTYPE;

Line 13356: FROM pay_payroll_actions ppa,pay_assignment_actions paa

13352: --cursor to check if run results exist for any FUR Pension Types for this assignment
13353: --in this period
13354: CURSOR c_run_results_exist IS
13355: SELECT paa.assignment_action_id
13356: FROM pay_payroll_actions ppa,pay_assignment_actions paa
13357: WHERE paa.payroll_action_id = ppa.payroll_action_id
13358: AND ppa.date_earned BETWEEN g_extract_params(p_business_group_id).extract_start_date
13359: AND g_extract_params(p_business_group_id).extract_end_date
13360: AND paa.assignment_id = p_assignment_id

Line 13449: pay_assignment_actions paa,

13445: SELECT prr.assignment_action_id,
13446: pei.eei_information9
13447: FROM pay_run_results prr,
13448: pay_payroll_actions ppa,
13449: pay_assignment_actions paa,
13450: pay_element_type_extra_info pei,
13451: pqp_pension_types_f pty
13452: WHERE paa.assignment_action_id = prr.assignment_action_id
13453: AND paa.payroll_action_id = ppa.payroll_action_id

Line 13739: FROM pay_payroll_actions ppa,pay_assignment_actions paa

13735: --cursor to check if run results exist for any IPAP Pension Types for this assignment
13736: --in this period
13737: CURSOR c_run_results_exist IS
13738: SELECT paa.assignment_action_id
13739: FROM pay_payroll_actions ppa,pay_assignment_actions paa
13740: WHERE paa.payroll_action_id = ppa.payroll_action_id
13741: AND ppa.date_earned BETWEEN g_extract_params(p_business_group_id).extract_start_date
13742: AND g_extract_params(p_business_group_id).extract_end_date
13743: AND paa.assignment_id = p_assignment_id