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 STANDARD

Line 5815: AND ppos2.last_standard_process_date IS NULL);

5811: AND TRUNC(ppos2.date_start) > TRUNC(ppos1.date_start)
5812: AND TRUNC(g_extract_params(p_business_group_id).extract_end_date) >= TRUNC(ppos2.date_start)
5813: AND ppos2.actual_termination_date IS NULL
5814: AND ppos2.final_process_date IS NULL
5815: AND ppos2.last_standard_process_date IS NULL);
5816: --9433900
5817:
5818: CURSOR c_rej_old_ee (c_ass_id IN NUMBER
5819: ,c_eff_dt IN DATE ) IS

Line 10379: FPU Standard (End 31-DEC-03) S

10375: /*
10376: Individual Schemes Code
10377: ============================= ======
10378: No Participation G
10379: FPU Standard (End 31-DEC-03) S
10380: FPU Extra C
10381: FPU Raise A
10382: FPU Total B
10383: FPU Base S

Line 13750: --find the defined balance id for the FUR Standard EE Contribution for the _ASG_PTD dimension

13746:
13747:
13748: BEGIN
13749:
13750: --find the defined balance id for the FUR Standard EE Contribution for the _ASG_PTD dimension
13751: Hr_Utility.set_location('Entering : '||l_proc,10);
13752: OPEN csr_defined_bal(c_balance_name => 'FUR Standard EE Contribution'
13753: ,c_dimension_name => 'Assignment Period To Date'
13754: ,c_business_group_id => p_business_group_id

Line 13752: OPEN csr_defined_bal(c_balance_name => 'FUR Standard EE Contribution'

13748: BEGIN
13749:
13750: --find the defined balance id for the FUR Standard EE Contribution for the _ASG_PTD dimension
13751: Hr_Utility.set_location('Entering : '||l_proc,10);
13752: OPEN csr_defined_bal(c_balance_name => 'FUR Standard EE Contribution'
13753: ,c_dimension_name => 'Assignment Period To Date'
13754: ,c_business_group_id => p_business_group_id
13755: );
13756: FETCH csr_defined_bal INTO l_defined_balance_id;

Line 14132: --find the defined balance id for the IPAP Standard EE Contribution for the _ASG_PTD dimension

14128: l_proc Varchar2(30) := 'get_ipap_contribution_amt';
14129:
14130: BEGIN
14131:
14132: --find the defined balance id for the IPAP Standard EE Contribution for the _ASG_PTD dimension
14133: Hr_Utility.set_location('Entering : '||l_proc,10);
14134: OPEN csr_defined_bal(c_balance_name => 'IPAP EE Contribution'
14135: ,c_dimension_name => 'Assignment Period To Date'
14136: ,c_business_group_id => p_business_group_id