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_TIAALOD_PKG dependencies on PER_ASSIGNMENTS_F

Line 37: l_payroll_id per_assignments_f.payroll_id%TYPE;

33: l_dob per_all_people_f.date_of_birth%TYPE;
34: l_asg_ppg_code per_assignment_extra_info.aei_information1%TYPE;
35: l_pay_mode pay_payrolls_f.prl_information4%TYPE;
36: l_ppg_billing pay_payrolls_f.prl_information7%TYPE;
37: l_payroll_id per_assignments_f.payroll_id%TYPE;
38: l_org_ppg hr_organization_information.org_information1%TYPE;
39: l_err_msg VARCHAR2(800);
40: l_err_num VARCHAR2(800);
41: l_chunk_no number;

Line 45: TYPE r_pay_mode IS RECORD (payroll_id per_assignments_f.payroll_id%TYPE,

41: l_chunk_no number;
42: l_ld_payroll_id pay_payroll_actions.payroll_id%TYPE;
43: l_prev_payroll_id pay_payroll_actions.payroll_id%TYPE;
44:
45: TYPE r_pay_mode IS RECORD (payroll_id per_assignments_f.payroll_id%TYPE,
46: payment_mode pay_payrolls_f.prl_information4%TYPE,
47: ppg_billing_code pay_payrolls_f.prl_information7%TYPE,
48: effective_date date);
49:

Line 86: input_date per_assignments_f.effective_end_date%TYPE,

82: balance_name5 pay_balance_types.balance_name%TYPE,
83: balance_value5 NUMBER,
84: balance_name6 pay_balance_types.balance_name%TYPE,
85: balance_value6 NUMBER,
86: input_date per_assignments_f.effective_end_date%TYPE,
87: input_start_date per_assignments_f.effective_end_date%TYPE,
88: assignment_id per_assignments_f.assignment_id%TYPE,
89: assignment_action_id pay_assignment_actions.assignment_action_id%TYPE,
90: err_num VARCHAR2(800),

Line 87: input_start_date per_assignments_f.effective_end_date%TYPE,

83: balance_value5 NUMBER,
84: balance_name6 pay_balance_types.balance_name%TYPE,
85: balance_value6 NUMBER,
86: input_date per_assignments_f.effective_end_date%TYPE,
87: input_start_date per_assignments_f.effective_end_date%TYPE,
88: assignment_id per_assignments_f.assignment_id%TYPE,
89: assignment_action_id pay_assignment_actions.assignment_action_id%TYPE,
90: err_num VARCHAR2(800),
91: err_msg VARCHAR2(800),

Line 88: assignment_id per_assignments_f.assignment_id%TYPE,

84: balance_name6 pay_balance_types.balance_name%TYPE,
85: balance_value6 NUMBER,
86: input_date per_assignments_f.effective_end_date%TYPE,
87: input_start_date per_assignments_f.effective_end_date%TYPE,
88: assignment_id per_assignments_f.assignment_id%TYPE,
89: assignment_action_id pay_assignment_actions.assignment_action_id%TYPE,
90: err_num VARCHAR2(800),
91: err_msg VARCHAR2(800),
92: payroll_id NUMBER

Line 215: i per_assignments_f.assignment_id%TYPE;

211: ,p_effective_date IN DATE
212: ,p_ppa_finder IN VARCHAR2) IS
213: l_insert_valid BOOLEAN := FALSE;
214: l_proc_name VARCHAR2(150) := g_proc_name ||'insert_rpt_data';
215: i per_assignments_f.assignment_id%TYPE;
216:
217: BEGIN
218: hr_utility.set_location('Entering : '||l_proc_name, 10);
219: -- Check if for the assignment id if there are any non-zero balances

Line 363: l_input_date per_assignments_f.effective_end_date%TYPE;

359: l_def_balance_id pay_defined_balances.defined_balance_id%TYPE;
360: l_balance_name pay_balance_types.balance_name%TYPE := ' ';
361: l_tax_id NUMBER;
362: l_count_bal NUMBER :=0;
363: l_input_date per_assignments_f.effective_end_date%TYPE;
364: l_input_start_date per_assignments_f.effective_start_date%TYPE;
365: v_start_date per_assignments_f.effective_start_date%TYPE;
366: v_end_date per_assignments_f.effective_end_date%TYPE;
367: l_update_flag BOOLEAN;

Line 364: l_input_start_date per_assignments_f.effective_start_date%TYPE;

360: l_balance_name pay_balance_types.balance_name%TYPE := ' ';
361: l_tax_id NUMBER;
362: l_count_bal NUMBER :=0;
363: l_input_date per_assignments_f.effective_end_date%TYPE;
364: l_input_start_date per_assignments_f.effective_start_date%TYPE;
365: v_start_date per_assignments_f.effective_start_date%TYPE;
366: v_end_date per_assignments_f.effective_end_date%TYPE;
367: l_update_flag BOOLEAN;
368: l_insert_valid BOOLEAN;

Line 365: v_start_date per_assignments_f.effective_start_date%TYPE;

361: l_tax_id NUMBER;
362: l_count_bal NUMBER :=0;
363: l_input_date per_assignments_f.effective_end_date%TYPE;
364: l_input_start_date per_assignments_f.effective_start_date%TYPE;
365: v_start_date per_assignments_f.effective_start_date%TYPE;
366: v_end_date per_assignments_f.effective_end_date%TYPE;
367: l_update_flag BOOLEAN;
368: l_insert_valid BOOLEAN;
369: l_proc_name VARCHAR2(150) := g_proc_name ||'load_balances';

Line 366: v_end_date per_assignments_f.effective_end_date%TYPE;

362: l_count_bal NUMBER :=0;
363: l_input_date per_assignments_f.effective_end_date%TYPE;
364: l_input_start_date per_assignments_f.effective_start_date%TYPE;
365: v_start_date per_assignments_f.effective_start_date%TYPE;
366: v_end_date per_assignments_f.effective_end_date%TYPE;
367: l_update_flag BOOLEAN;
368: l_insert_valid BOOLEAN;
369: l_proc_name VARCHAR2(150) := g_proc_name ||'load_balances';
370: i per_all_assignments_f.assignment_id%TYPE;

Line 539: lpayroll_id per_assignments_f.payroll_id%TYPE;

535: AND prl.prl_information_category = 'US'
536: AND l_effective_date BETWEEN prl.effective_start_date
537: AND prl.effective_end_date;
538: l_count NUMBER ;
539: lpayroll_id per_assignments_f.payroll_id%TYPE;
540: BEGIN
541: l_ppg_billing:='';
542: FOR i IN 1..pay_mode_t.count
543: LOOP

Line 579: lpayroll_id per_assignments_f.payroll_id%TYPE;

575: AND prl.prl_information_category = 'US'
576: AND l_effective_date BETWEEN prl.effective_start_date
577: AND prl.effective_end_date;
578: l_count NUMBER;
579: lpayroll_id per_assignments_f.payroll_id%TYPE;
580: BEGIN
581: l_pay_mode:='';
582: lpayroll_id:='';
583: l_ppg_billing:='';

Line 626: per_assignments_f pasg

622: CURSOR asg_ppg IS
623: SELECT paei.aei_information1,
624: pasg.payroll_id
625: FROM per_assignment_extra_info paei ,
626: per_assignments_f pasg
627: WHERE pasg.assignment_id = p_assignment
628: AND pasg.assignment_id = paei.assignment_id(+)
629: AND paei.information_type(+) = 'PQP_US_TIAA_CREF_CODES'
630: AND l_effective_date BETWEEN pasg.effective_start_date

Line 661: per_assignments_f paf

657: ppv.middle_names,
658: ppv.date_of_birth,
659: ppv.national_identifier
660: FROM per_all_people_f ppv,
661: per_assignments_f paf
662: WHERE paf.assignment_id = p_assignment
663: AND paf.person_id = ppv.person_id
664: AND l_actual_date BETWEEN ppv.effective_start_date
665: AND ppv.effective_end_date

Line 670: FROM per_assignments_f paf

666: AND l_actual_date BETWEEN paf.effective_start_date
667: AND paf.effective_end_date;
668: CURSOR asg_end_date IS
669: SELECT MAX(effective_end_date)
670: FROM per_assignments_f paf
671: WHERE paf.assignment_id = p_assignment
672: AND paf.business_group_id =l_business_group_id;
673:
674: BEGIN

Line 781: per_assignments_f paf,

777: ppa.payroll_id pay_payroll_id
778: FROM hr_locations_all hrl,
779: hr_organization_units hox,
780: hr_organization_units hou,
781: per_assignments_f paf,
782: pay_payroll_actions ppa,
783: pay_assignment_actions paa,
784: pay_action_interlocks pai,
785: pay_assignment_actions paa_gen,