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_ABP_FUNCTIONS dependencies on PER_ALL_ASSIGNMENTS_F

Line 90: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

86: -- ------------------------------------------------------------------------
87: --
88: FUNCTION get_reporting_date
89: (p_effective_date IN DATE
90: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
91: ,p_person_id IN per_all_people_f.person_id%TYPE
92: ,p_reporting_date OUT NOCOPY DATE
93: )
94: RETURN NUMBER IS

Line 185: FROM per_all_assignments_f

181: --Cursor to fetch the Assignment Start Date
182: --
183: CURSOR c_chk_assgn_start_date IS
184: SELECT effective_start_date
185: FROM per_all_assignments_f
186: WHERE (assignment_id = p_assignment_id)
187: AND assignment_type = 'E'
188: AND (TO_DATE('01/01/'||TO_CHAR(p_eff_date,'YYYY'),'dd/mm/yyyy')
189: BETWEEN effective_start_date and effective_end_date);

Line 196: FROM per_all_assignments_f

192: --Cursor to fetch the First Assignment Start Date of a particular year
193: --
194: CURSOR c_get_assgn_start_date IS
195: SELECT MIN(effective_start_date)
196: FROM per_all_assignments_f
197: WHERE assignment_id = p_assignment_id
198: AND assignment_type = 'E'
199: AND (effective_start_date
200: BETWEEN TO_DATE('01/01/'||TO_CHAR(p_eff_date,'YYYY'),'dd/mm/yyyy')

Line 1835: FROM per_all_assignments_f

1831: (SELECT period_type
1832: FROM pay_payrolls_f
1833: WHERE payroll_id =
1834: (SELECT payroll_id
1835: FROM per_all_assignments_f
1836: WHERE assignment_id = p_assignment_id
1837: AND c_eff_date BETWEEN effective_start_date
1838: AND nvl(effective_end_date,hr_api.g_eot)
1839: )

Line 1907: FROM per_all_assignments_f asg

1903:
1904: --Cursor to fetch the hire date of the employee
1905: CURSOR c_get_hire_date(c_eff_date in date) IS
1906: SELECT max(date_start)
1907: FROM per_all_assignments_f asg
1908: ,per_periods_of_service pps
1909: WHERE pps.person_id = asg.person_id
1910: AND asg.assignment_id = p_assignment_id
1911: AND pps.business_group_id = asg.business_group_id

Line 1924: Select person_id from per_all_assignments_f

1920: AND information_type = 'PQP_NL_ABP_DEDUCTION'
1921: AND eei_information2 = c_pension_type_id;
1922:
1923: CURSOR c_get_person_id IS
1924: Select person_id from per_all_assignments_f
1925: where assignment_id = p_assignment_id;
1926:
1927: CURSOR c_get_eff_date IS
1928: SELECT effective_date

Line 2809: FROM per_all_assignments_f

2805: (SELECT period_type
2806: FROM pay_payrolls_f
2807: WHERE payroll_id =
2808: (SELECT payroll_id
2809: FROM per_all_assignments_f
2810: WHERE assignment_id = p_assignment_id
2811: AND c_eff_date BETWEEN effective_start_date
2812: AND nvl(effective_end_date,hr_api.g_eot)
2813: )

Line 2865: FROM per_all_assignments_f asg

2861:
2862: --Cursor to fetch the hire date of the employee
2863: CURSOR c_get_hire_date(c_eff_date in date) IS
2864: SELECT max(date_start)
2865: FROM per_all_assignments_f asg
2866: ,per_periods_of_service pps
2867: WHERE pps.person_id = asg.person_id
2868: AND asg.assignment_id = p_assignment_id
2869: AND pps.business_group_id = asg.business_group_id

Line 2888: Select person_id from per_all_assignments_f

2884: FROM fnd_sessions
2885: WHERE session_id = userenv('sessionid');
2886:
2887: CURSOR c_get_person_id IS
2888: Select person_id from per_all_assignments_f
2889: where assignment_id = p_assignment_id;
2890:
2891: CURSOR c_run_results_exist IS
2892: SELECT ppa.date_earned

Line 3836: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

3832: --
3833: -- Funtion to get the prorated value of ptpn
3834: --
3835: FUNCTION get_vop
3836: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
3837: ,p_date_earned IN DATE
3838: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
3839: ,p_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE
3840: ,p_vop OUT NOCOPY VARCHAR2

Line 3848: FROM per_all_assignments_f asg

3844: --cursor to fetch the pay period start and end dates
3845: --for the particular assignment
3846: CURSOR c_get_period_dates IS
3847: SELECT ptp.start_date,ptp.end_date
3848: FROM per_all_assignments_f asg
3849: ,per_time_periods ptp
3850: WHERE asg.assignment_id = p_assignment_id
3851: AND asg.payroll_id = ptp.payroll_id
3852: AND p_date_earned BETWEEN ptp.start_date

Line 4121: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

4117: -- |------------------< get_assignment_attribute >-------------------------|
4118: -- ------------------------------------------------------------------------
4119: --
4120: FUNCTION get_assignment_attribute
4121: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4122: ,p_date_earned in date
4123: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
4124: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE
4125: ,p_attrib_name in varchar2

Line 4407: ( p_assignment_id in per_all_assignments_f.assignment_id%TYPE

4403: --
4404:
4405:
4406: FUNCTION get_contribution_percent
4407: ( p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4408: ,p_date_earned in date
4409: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
4410: ,p_pension_sub_cat in pqp_pension_types_f.pension_sub_category%TYPE
4411: ,p_udt_table_name in VARCHAR2

Line 4418: FROM per_all_people_f per,per_all_assignments_f paa

4414: RETURN NUMBER IS
4415:
4416: CURSOR c_get_person_age IS
4417: SELECT to_char(per.date_of_birth,'RRRR')
4418: FROM per_all_people_f per,per_all_assignments_f paa
4419: WHERE per.person_id = paa.person_id
4420: AND p_date_earned between paa.effective_start_date and paa.effective_end_date
4421: AND p_date_earned between per.effective_start_date and per.effective_end_date
4422: AND paa.assignment_id = p_assignment_id;

Line 4520: ( p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

4516: -- |-----------------------< chk_pt_eligibility >--------------------------|
4517: -- ------------------------------------------------------------------------
4518: --
4519: FUNCTION chk_pt_eligibility
4520: ( p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
4521: ,p_date_earned IN DATE
4522: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
4523: ,p_pt_id IN NUMBER
4524: ,p_hr_org_org_id IN NUMBER

Line 4631: ( p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

4627: -- |------------------< get_abp_org_contrib_percent >----------------------|
4628: -- ------------------------------------------------------------------------
4629: --
4630: FUNCTION get_abp_org_contrib_percent
4631: ( p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
4632: ,p_date_earned IN DATE
4633: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
4634: ,p_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE
4635: ,p_ee_contrib OUT NOCOPY NUMBER

Line 4667: FROM per_all_assignments_f asg,

4663: CURSOR c_find_org IS
4664: SELECT asg.organization_id
4665: ,asg.payroll_id
4666: ,fnd_number.canonical_to_number(ppf.prl_information1)
4667: FROM per_all_assignments_f asg,
4668: pay_payrolls_f ppf
4669: WHERE asg.assignment_id = p_assignment_id
4670: AND asg.payroll_id = ppf.payroll_id
4671: AND TRUNC(p_date_earned) BETWEEN asg.effective_start_date

Line 4888: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

4884: -- |------------------< get_abp_contribution >----------------------------|
4885: -- ------------------------------------------------------------------------
4886: --
4887: FUNCTION get_abp_contribution
4888: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
4889: ,p_date_earned IN DATE
4890: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
4891: ,p_payroll_action_id IN NUMBER
4892: ,p_pension_sub_cat IN pqp_pension_types_f.pension_sub_category%TYPE

Line 4989: FROM per_all_assignments_f asg,

4985: CURSOR c_find_org (c_date_earned IN DATE)IS
4986: SELECT asg.organization_id
4987: ,asg.payroll_id
4988: ,fnd_number.canonical_to_number(ppf.prl_information1)
4989: FROM per_all_assignments_f asg,
4990: pay_payrolls_f ppf
4991: WHERE asg.assignment_id = p_assignment_id
4992: AND asg.payroll_id = ppf.payroll_id
4993: AND TRUNC(c_date_earned) BETWEEN asg.effective_start_date

Line 5520: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

5516: -- |------------------< get_participation_date >----------------------------|
5517: -- ------------------------------------------------------------------------
5518: --
5519: FUNCTION get_participation_date
5520: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5521: ,p_date_earned in date
5522: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
5523: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE
5524: ,p_start_date out NOCOPY date

Line 5540: FROM per_all_assignments_f

5536:
5537: --Cursor to find the org id from the assignment id
5538: CURSOR c_find_org_id IS
5539: SELECT organization_id
5540: FROM per_all_assignments_f
5541: WHERE assignment_id = p_assignment_id
5542: AND trunc(p_date_earned) between effective_start_date and effective_end_date
5543: AND business_group_id = p_business_group_id;
5544:

Line 5729: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

5725: -- |------------------< get_participation_org >----------------------------|
5726: -- ------------------------------------------------------------------------
5727: --
5728: PROCEDURE get_participation_org
5729: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5730: ,p_date_earned in date
5731: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE
5732: ,p_asg_or_org out NOCOPY number
5733: ,p_org_id out NOCOPY number

Line 5749: FROM per_all_assignments_f

5745:
5746: --Cursor to find the org id from the assignment id
5747: CURSOR c_find_org_id IS
5748: SELECT organization_id,business_group_id
5749: FROM per_all_assignments_f
5750: WHERE assignment_id = p_assignment_id
5751: AND trunc(p_date_earned) between effective_start_date and effective_end_date;
5752:
5753: --Cursor to find the named hierarchy associated with the BG

Line 6009: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

6005: -- |--------------------< get_absence_adjustment >------------------------|
6006: -- ------------------------------------------------------------------------
6007: --
6008: FUNCTION get_absence_adjustment
6009: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
6010: ,p_date_earned in date
6011: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
6012: ,p_dedn_amt in number
6013: ,p_adjust_amt out NOCOPY number

Line 6022: FROM per_all_assignments_f asg

6018: --cursor to fetch the pay period start and end dates
6019: --for the particular assignment
6020: CURSOR c_get_period_dates IS
6021: SELECT ptp.start_date,ptp.end_date
6022: FROM per_all_assignments_f asg
6023: ,per_time_periods ptp
6024: WHERE asg.assignment_id = p_assignment_id
6025: AND asg.payroll_id = ptp.payroll_id
6026: AND p_date_earned BETWEEN ptp.start_date

Line 6211: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

6207: -- |----------------------< get_proration_factor>--------------------------|
6208: -- ------------------------------------------------------------------------
6209: --
6210: FUNCTION get_proration_factor
6211: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
6212: ,p_date_earned in date
6213: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
6214: ,p_proration_factor out NOCOPY number
6215: ,p_error_message out NOCOPY varchar2

Line 6223: FROM per_all_assignments_f asg

6219: --cursor to fetch the pay period start and end dates
6220: --for the particular assignment
6221: CURSOR c_get_period_dates IS
6222: SELECT ptp.start_date,ptp.end_date
6223: FROM per_all_assignments_f asg
6224: ,per_time_periods ptp
6225: WHERE asg.assignment_id = p_assignment_id
6226: AND asg.payroll_id = ptp.payroll_id
6227: AND p_date_earned BETWEEN ptp.start_date

Line 6326: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

6322: --
6323: FUNCTION get_abp_calc_eff_dt
6324: (p_date_earned IN DATE
6325: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
6326: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
6327: ,p_effective_date OUT NOCOPY DATE
6328: )
6329:
6330: RETURN NUMBER IS

Line 6335: FROM per_all_assignments_f asg

6331:
6332: -- Cursor to get the hire date of the person
6333: CURSOR c_hire_dt_cur(c_asg_id IN NUMBER) IS
6334: SELECT max(date_start)
6335: FROM per_all_assignments_f asg
6336: ,per_periods_of_service pps
6337: WHERE pps.person_id = asg.person_id
6338: AND asg.assignment_id = c_asg_id
6339: AND pps.business_group_id = p_business_group_id

Line 6345: FROM per_all_assignments_f

6341:
6342: --cursor to fetch the assignment start date
6343: CURSOR c_get_asg_start IS
6344: SELECT min(effective_start_date)
6345: FROM per_all_assignments_f
6346: WHERE assignment_id = p_assignment_id
6347: AND assignment_type = 'E';
6348:
6349: l_run_year NUMBER;

Line 6406: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

6402: --
6403: FUNCTION get_proration_flag
6404: (p_date_earned IN DATE
6405: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
6406: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
6407: ,p_assignment_action_id IN per_all_assignments_f.assignment_id%TYPE
6408: ,p_element_type_id IN pay_element_types_f.element_type_id%TYPE
6409: ,p_start_date IN DATE
6410: ,p_end_date IN DATE

Line 6407: ,p_assignment_action_id IN per_all_assignments_f.assignment_id%TYPE

6403: FUNCTION get_proration_flag
6404: (p_date_earned IN DATE
6405: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
6406: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
6407: ,p_assignment_action_id IN per_all_assignments_f.assignment_id%TYPE
6408: ,p_element_type_id IN pay_element_types_f.element_type_id%TYPE
6409: ,p_start_date IN DATE
6410: ,p_end_date IN DATE
6411: )

Line 6449: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

6445: --
6446: FUNCTION get_eoy_bonus_percentage
6447: (p_date_earned IN date
6448: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
6449: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
6450: ,p_eoy_bonus_percentage OUT NOCOPY number
6451: )
6452: RETURN NUMBER IS
6453:

Line 6457: FROM per_all_assignments_f

6453:
6454: --Cursor to find the org id from the assignment id
6455: CURSOR c_find_org_id IS
6456: SELECT organization_id
6457: FROM per_all_assignments_f
6458: WHERE assignment_id = p_assignment_id
6459: AND trunc(p_date_earned) between effective_start_date and effective_end_date
6460: AND business_group_id = p_business_group_id;
6461:

Line 7119: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE

7115: --
7116: function abp_proration
7117: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
7118: ,p_date_earned in date
7119: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
7120: ,p_amount in number
7121: ,p_payroll_period in varchar2
7122: ,p_work_pattern in varchar2
7123: ,p_conversion_rule in varchar2