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.PAY_JP_UITE_ARCH_PKG dependencies on PAY_JP_BALANCE_PKG

Line 127: ln_life_ins_org_id := pay_jp_balance_pkg.get_entry_value_number(p_element_name => 'COM_LI_INFO'

123: lc_procedure := gc_package||'get_life_ins_org';
124: hr_utility.set_location('Entering '||lc_procedure,1);
125: END IF;
126: --
127: ln_life_ins_org_id := pay_jp_balance_pkg.get_entry_value_number(p_element_name => 'COM_LI_INFO'
128: ,p_input_value_name => 'EI_LOCATION'
129: ,p_assignment_id => p_assignment_id
130: ,p_effective_date => p_effective_date
131: );

Line 186: lc_ei_type := pay_jp_balance_pkg.get_entry_value_char(p_element_name => 'COM_LI_INFO'

182: lc_procedure := gc_package||'get_ei_type';
183: hr_utility.set_location('Entering '||lc_procedure,1);
184: END IF;
185: --
186: lc_ei_type := pay_jp_balance_pkg.get_entry_value_char(p_element_name => 'COM_LI_INFO'
187: ,p_input_value_name => 'EI_TYPE'
188: ,p_assignment_id => p_assignment_id
189: ,p_effective_date => p_effective_date
190: );

Line 245: lc_term_rpt_flag := pay_jp_balance_pkg.get_entry_value_char(p_element_name => 'COM_EI_QUALIFY_INFO'

241: lc_procedure := gc_package||'get_term_rpt_flag';
242: hr_utility.set_location('Entering '||lc_procedure,1);
243: END IF;
244: --
245: lc_term_rpt_flag := pay_jp_balance_pkg.get_entry_value_char(p_element_name => 'COM_EI_QUALIFY_INFO'
246: ,p_input_value_name => 'TRM_REPORT_OUTPUT_FLAG'
247: ,p_assignment_id => p_assignment_id
248: ,p_effective_date => p_effective_date
249: );

Line 304: ld_qualify_date := pay_jp_balance_pkg.get_entry_value_date(p_element_name => 'COM_EI_QUALIFY_INFO'

300: lc_procedure := gc_package||'get_ei_quality_date';
301: hr_utility.set_location('Entering '||lc_procedure,1);
302: END IF;
303: --
304: ld_qualify_date := pay_jp_balance_pkg.get_entry_value_date(p_element_name => 'COM_EI_QUALIFY_INFO'
305: ,p_input_value_name => 'QUALIFY_DATE'
306: ,p_assignment_id => p_assignment_id
307: ,p_effective_date => p_effective_date
308: );

Line 363: ld_qualify_date := pay_jp_balance_pkg.get_entry_value_date(p_element_name => 'COM_EI_QUALIFY_INFO'

359: lc_procedure := gc_package||'get_ei_dis_qual_date';
360: hr_utility.set_location('Entering '||lc_procedure,1);
361: END IF;
362: --
363: ld_qualify_date := pay_jp_balance_pkg.get_entry_value_date(p_element_name => 'COM_EI_QUALIFY_INFO'
364: ,p_input_value_name => 'DISQUALIFY_DATE'
365: ,p_assignment_id => p_assignment_id
366: ,p_effective_date => p_effective_date
367: );

Line 423: lc_ui_num := pay_jp_balance_pkg.get_entry_value_char(p_element_name => 'COM_LI_INFO'

419: lc_procedure := gc_package||'get_ui_num';
420: hr_utility.set_location('Entering '||lc_procedure,1);
421: END IF;
422: --
423: lc_ui_num := pay_jp_balance_pkg.get_entry_value_char(p_element_name => 'COM_LI_INFO'
424: ,p_input_value_name => 'EI_NUM'
425: ,p_assignment_id => p_assignment_id
426: ,p_effective_date => p_effective_date
427: );

Line 1300: ln_base_days := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_WAGE_PAY_INFO','PAY_PERIOD_BASE_DAYS',p_assignment_id,lt_assact_tbl(assact_cnt).date_earned);

1296: --
1297: EXIT WHEN ((TRUNC(MONTHS_BETWEEN(p_termination_date,ld_period_start_date)/12)>=4 ));
1298: --
1299: ln_assignment_action_id := lt_assact_tbl(assact_cnt).assignment_action_id;
1300: ln_base_days := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_WAGE_PAY_INFO','PAY_PERIOD_BASE_DAYS',p_assignment_id,lt_assact_tbl(assact_cnt).date_earned);
1301: --
1302: IF ln_base_days IS NULL THEN
1303: --
1304: IF ln_assignment_action_id IS NOT NULL THEN --Bug 9693280

Line 1306: ln_base_days := pay_jp_balance_pkg.get_balance_value(ln_bpd_balance_id,ln_assignment_action_id);

1302: IF ln_base_days IS NULL THEN
1303: --
1304: IF ln_assignment_action_id IS NOT NULL THEN --Bug 9693280
1305: --
1306: ln_base_days := pay_jp_balance_pkg.get_balance_value(ln_bpd_balance_id,ln_assignment_action_id);
1307: --
1308: END IF;
1309: --
1310: IF ( NVL(ln_base_days,0) = 0)THEN -- #Bug No 9652251

Line 1349: ln_wage_pay_days := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_WAGE_PAY_INFO','EE_PERIOD_BASE_DAYS',p_assignment_id,ld_insured_end_date);

1345: --
1346: END IF;
1347: END IF;
1348: --
1349: ln_wage_pay_days := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_WAGE_PAY_INFO','EE_PERIOD_BASE_DAYS',p_assignment_id,ld_insured_end_date);
1350: --
1351: -- Fecthing Start and End insured/pay periods
1352: --
1353: IF TRUNC(p_hire_date) > TRUNC(ld_insured_start_date) THEN

Line 1415: ln_wage_amount_a := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_WAGE_PAY_INFO','WAGE_A',p_assignment_id,lt_assact_tbl(assact_cnt).date_earned);

1411: CLOSE lcu_balance_asg_prev_run;
1412: --
1413: -- Derving Wage Amount A
1414: --
1415: ln_wage_amount_a := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_WAGE_PAY_INFO','WAGE_A',p_assignment_id,lt_assact_tbl(assact_cnt).date_earned);
1416: --
1417: IF ln_wage_amount_a IS NULL THEN
1418: --
1419: IF lc_sal_a_bal_flag = 'Y' THEN

Line 1423: ln_wage_amount_a := pay_jp_balance_pkg.get_balance_value(ln_sal_a_bal_id,ln_assignment_action_id)

1419: IF lc_sal_a_bal_flag = 'Y' THEN
1420: --
1421: IF ln_prev_ass_a_act_id IS NOT NULL THEN
1422: --
1423: ln_wage_amount_a := pay_jp_balance_pkg.get_balance_value(ln_sal_a_bal_id,ln_assignment_action_id)
1424: + pay_jp_balance_pkg.get_balance_value(ln_sal_a_prev_bal_id,ln_prev_ass_a_act_id);
1425: ELSE
1426: --
1427: ln_wage_amount_a := pay_jp_balance_pkg.get_balance_value(ln_sal_a_bal_id,ln_assignment_action_id);

Line 1424: + pay_jp_balance_pkg.get_balance_value(ln_sal_a_prev_bal_id,ln_prev_ass_a_act_id);

1420: --
1421: IF ln_prev_ass_a_act_id IS NOT NULL THEN
1422: --
1423: ln_wage_amount_a := pay_jp_balance_pkg.get_balance_value(ln_sal_a_bal_id,ln_assignment_action_id)
1424: + pay_jp_balance_pkg.get_balance_value(ln_sal_a_prev_bal_id,ln_prev_ass_a_act_id);
1425: ELSE
1426: --
1427: ln_wage_amount_a := pay_jp_balance_pkg.get_balance_value(ln_sal_a_bal_id,ln_assignment_action_id);
1428: --

Line 1427: ln_wage_amount_a := pay_jp_balance_pkg.get_balance_value(ln_sal_a_bal_id,ln_assignment_action_id);

1423: ln_wage_amount_a := pay_jp_balance_pkg.get_balance_value(ln_sal_a_bal_id,ln_assignment_action_id)
1424: + pay_jp_balance_pkg.get_balance_value(ln_sal_a_prev_bal_id,ln_prev_ass_a_act_id);
1425: ELSE
1426: --
1427: ln_wage_amount_a := pay_jp_balance_pkg.get_balance_value(ln_sal_a_bal_id,ln_assignment_action_id);
1428: --
1429: END IF;
1430: --
1431: ELSE

Line 1435: ln_wage_amount_a := pay_jp_balance_pkg.get_balance_value(ln_sal_a_prev_bal_id,ln_prev_ass_a_act_id);

1431: ELSE
1432: --
1433: IF ln_prev_ass_a_act_id IS NOT NULL THEN
1434: --
1435: ln_wage_amount_a := pay_jp_balance_pkg.get_balance_value(ln_sal_a_prev_bal_id,ln_prev_ass_a_act_id);
1436: --
1437: END IF;
1438: --
1439: END IF;

Line 1445: ln_wage_amount_b := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_WAGE_PAY_INFO','WAGE_B',p_assignment_id,lt_assact_tbl(assact_cnt).date_earned);

1441: --
1442: END IF;
1443: -- Derving Wage Amount B
1444: --
1445: ln_wage_amount_b := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_WAGE_PAY_INFO','WAGE_B',p_assignment_id,lt_assact_tbl(assact_cnt).date_earned);
1446: --
1447: IF ln_wage_amount_b IS NULL THEN
1448: --
1449: IF lc_sal_b_bal_flag = 'Y' THEN

Line 1453: ln_wage_amount_b := pay_jp_balance_pkg.get_balance_value(ln_sal_b_bal_id,ln_assignment_action_id)

1449: IF lc_sal_b_bal_flag = 'Y' THEN
1450: --
1451: IF ln_prev_ass_b_act_id IS NOT NULL THEN
1452: --
1453: ln_wage_amount_b := pay_jp_balance_pkg.get_balance_value(ln_sal_b_bal_id,ln_assignment_action_id)
1454: + pay_jp_balance_pkg.get_balance_value(ln_sal_b_prev_bal_id,ln_prev_ass_b_act_id );
1455: --
1456: ELSE
1457: --

Line 1454: + pay_jp_balance_pkg.get_balance_value(ln_sal_b_prev_bal_id,ln_prev_ass_b_act_id );

1450: --
1451: IF ln_prev_ass_b_act_id IS NOT NULL THEN
1452: --
1453: ln_wage_amount_b := pay_jp_balance_pkg.get_balance_value(ln_sal_b_bal_id,ln_assignment_action_id)
1454: + pay_jp_balance_pkg.get_balance_value(ln_sal_b_prev_bal_id,ln_prev_ass_b_act_id );
1455: --
1456: ELSE
1457: --
1458: ln_wage_amount_b := pay_jp_balance_pkg.get_balance_value(ln_sal_b_bal_id,ln_assignment_action_id);

Line 1458: ln_wage_amount_b := pay_jp_balance_pkg.get_balance_value(ln_sal_b_bal_id,ln_assignment_action_id);

1454: + pay_jp_balance_pkg.get_balance_value(ln_sal_b_prev_bal_id,ln_prev_ass_b_act_id );
1455: --
1456: ELSE
1457: --
1458: ln_wage_amount_b := pay_jp_balance_pkg.get_balance_value(ln_sal_b_bal_id,ln_assignment_action_id);
1459: --
1460: END IF;
1461: --
1462: ELSE

Line 1466: ln_wage_amount_b := pay_jp_balance_pkg.get_balance_value(ln_sal_b_prev_bal_id,ln_prev_ass_b_act_id );

1462: ELSE
1463: --
1464: IF ln_prev_ass_b_act_id IS NOT NULL THEN
1465: --
1466: ln_wage_amount_b := pay_jp_balance_pkg.get_balance_value(ln_sal_b_prev_bal_id,ln_prev_ass_b_act_id );
1467: --
1468: END IF;
1469: --
1470: END IF;

Line 1494: lc_exclude_period := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_WAGE_PAY_INFO','EXCLUDE_PERIOD',p_assignment_id,lt_assact_tbl(assact_cnt).date_earned);

1490: lc_wage_b_flag := 'Y';
1491: --
1492: END IF;
1493: --
1494: lc_exclude_period := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_WAGE_PAY_INFO','EXCLUDE_PERIOD',p_assignment_id,lt_assact_tbl(assact_cnt).date_earned);
1495: lc_remarks := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_WAGE_PAY_INFO','RMKS',p_assignment_id,lt_assact_tbl(assact_cnt).date_earned);
1496: --
1497: IF gb_debug THEN
1498: hr_utility.set_location('Payment Date '||lt_assact_tbl(assact_cnt).effective_date,11);

Line 1495: lc_remarks := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_WAGE_PAY_INFO','RMKS',p_assignment_id,lt_assact_tbl(assact_cnt).date_earned);

1491: --
1492: END IF;
1493: --
1494: lc_exclude_period := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_WAGE_PAY_INFO','EXCLUDE_PERIOD',p_assignment_id,lt_assact_tbl(assact_cnt).date_earned);
1495: lc_remarks := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_WAGE_PAY_INFO','RMKS',p_assignment_id,lt_assact_tbl(assact_cnt).date_earned);
1496: --
1497: IF gb_debug THEN
1498: hr_utility.set_location('Payment Date '||lt_assact_tbl(assact_cnt).effective_date,11);
1499: hr_utility.set_location('Insured Period Start Date '||ld_insured_start_date,12);

Line 1858: ln_spb_earnings := pay_jp_balance_pkg.get_balance_value(ln_spb_bal_id,lt_spb_assact_tbl(spb_assact_cnt).assignment_action_id);

1854: --
1855: <>
1856: FOR spb_assact_cnt in lt_spb_assact_tbl.first..lt_spb_assact_tbl.last LOOP
1857: --
1858: ln_spb_earnings := pay_jp_balance_pkg.get_balance_value(ln_spb_bal_id,lt_spb_assact_tbl(spb_assact_cnt).assignment_action_id);
1859: --
1860: --
1861: pay_action_information_api.create_action_information
1862: ( p_action_information_id => ln_action_info_id

Line 1953: lc_wage_note := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_INFO','WAGE_SP_DESC',p_assignment_id,p_termination_date);

1949: END IF;
1950: --
1951: --Wage Instructions
1952: --
1953: lc_wage_note := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_INFO','WAGE_SP_DESC',p_assignment_id,p_termination_date);
1954: lc_wage_note2 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_INFO','WAGE_SP_DESC2',p_assignment_id,p_termination_date);
1955: lc_wage_note3 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_INFO','WAGE_SP_DESC3',p_assignment_id,p_termination_date);
1956: lc_wage_note4 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_INFO','WAGE_SP_DESC4',p_assignment_id,p_termination_date);
1957: lc_wage_note5 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_INFO','WAGE_SP_DESC5',p_assignment_id,p_termination_date);

Line 1954: lc_wage_note2 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_INFO','WAGE_SP_DESC2',p_assignment_id,p_termination_date);

1950: --
1951: --Wage Instructions
1952: --
1953: lc_wage_note := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_INFO','WAGE_SP_DESC',p_assignment_id,p_termination_date);
1954: lc_wage_note2 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_INFO','WAGE_SP_DESC2',p_assignment_id,p_termination_date);
1955: lc_wage_note3 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_INFO','WAGE_SP_DESC3',p_assignment_id,p_termination_date);
1956: lc_wage_note4 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_INFO','WAGE_SP_DESC4',p_assignment_id,p_termination_date);
1957: lc_wage_note5 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_INFO','WAGE_SP_DESC5',p_assignment_id,p_termination_date);
1958: --

Line 1955: lc_wage_note3 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_INFO','WAGE_SP_DESC3',p_assignment_id,p_termination_date);

1951: --Wage Instructions
1952: --
1953: lc_wage_note := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_INFO','WAGE_SP_DESC',p_assignment_id,p_termination_date);
1954: lc_wage_note2 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_INFO','WAGE_SP_DESC2',p_assignment_id,p_termination_date);
1955: lc_wage_note3 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_INFO','WAGE_SP_DESC3',p_assignment_id,p_termination_date);
1956: lc_wage_note4 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_INFO','WAGE_SP_DESC4',p_assignment_id,p_termination_date);
1957: lc_wage_note5 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_INFO','WAGE_SP_DESC5',p_assignment_id,p_termination_date);
1958: --
1959: lc_wage_instr1 := lc_wage_note || lc_wage_note2 ||lc_wage_note3;

Line 1956: lc_wage_note4 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_INFO','WAGE_SP_DESC4',p_assignment_id,p_termination_date);

1952: --
1953: lc_wage_note := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_INFO','WAGE_SP_DESC',p_assignment_id,p_termination_date);
1954: lc_wage_note2 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_INFO','WAGE_SP_DESC2',p_assignment_id,p_termination_date);
1955: lc_wage_note3 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_INFO','WAGE_SP_DESC3',p_assignment_id,p_termination_date);
1956: lc_wage_note4 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_INFO','WAGE_SP_DESC4',p_assignment_id,p_termination_date);
1957: lc_wage_note5 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_INFO','WAGE_SP_DESC5',p_assignment_id,p_termination_date);
1958: --
1959: lc_wage_instr1 := lc_wage_note || lc_wage_note2 ||lc_wage_note3;
1960: --

Line 1957: lc_wage_note5 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_INFO','WAGE_SP_DESC5',p_assignment_id,p_termination_date);

1953: lc_wage_note := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_INFO','WAGE_SP_DESC',p_assignment_id,p_termination_date);
1954: lc_wage_note2 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_INFO','WAGE_SP_DESC2',p_assignment_id,p_termination_date);
1955: lc_wage_note3 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_INFO','WAGE_SP_DESC3',p_assignment_id,p_termination_date);
1956: lc_wage_note4 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_INFO','WAGE_SP_DESC4',p_assignment_id,p_termination_date);
1957: lc_wage_note5 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_INFO','WAGE_SP_DESC5',p_assignment_id,p_termination_date);
1958: --
1959: lc_wage_instr1 := lc_wage_note || lc_wage_note2 ||lc_wage_note3;
1960: --
1961: lc_wage_instr2 := lc_wage_note4 ||lc_wage_note5;

Line 1965: lc_term_reason := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','TRM_REASON',p_assignment_id,p_termination_date);

1961: lc_wage_instr2 := lc_wage_note4 ||lc_wage_note5;
1962: --
1963: -- Termination Details
1964: --
1965: lc_term_reason := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','TRM_REASON',p_assignment_id,p_termination_date);
1966: lc_reason_detail := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL',p_assignment_id,p_termination_date);
1967: lc_reason_detail2 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL2',p_assignment_id,p_termination_date);
1968: lc_reason_detail3 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL3',p_assignment_id,p_termination_date);
1969: lc_reason_detail4 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL4',p_assignment_id,p_termination_date);

Line 1966: lc_reason_detail := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL',p_assignment_id,p_termination_date);

1962: --
1963: -- Termination Details
1964: --
1965: lc_term_reason := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','TRM_REASON',p_assignment_id,p_termination_date);
1966: lc_reason_detail := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL',p_assignment_id,p_termination_date);
1967: lc_reason_detail2 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL2',p_assignment_id,p_termination_date);
1968: lc_reason_detail3 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL3',p_assignment_id,p_termination_date);
1969: lc_reason_detail4 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL4',p_assignment_id,p_termination_date);
1970: lc_reason_detail5 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL5',p_assignment_id,p_termination_date);

Line 1967: lc_reason_detail2 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL2',p_assignment_id,p_termination_date);

1963: -- Termination Details
1964: --
1965: lc_term_reason := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','TRM_REASON',p_assignment_id,p_termination_date);
1966: lc_reason_detail := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL',p_assignment_id,p_termination_date);
1967: lc_reason_detail2 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL2',p_assignment_id,p_termination_date);
1968: lc_reason_detail3 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL3',p_assignment_id,p_termination_date);
1969: lc_reason_detail4 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL4',p_assignment_id,p_termination_date);
1970: lc_reason_detail5 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL5',p_assignment_id,p_termination_date);
1971: --

Line 1968: lc_reason_detail3 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL3',p_assignment_id,p_termination_date);

1964: --
1965: lc_term_reason := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','TRM_REASON',p_assignment_id,p_termination_date);
1966: lc_reason_detail := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL',p_assignment_id,p_termination_date);
1967: lc_reason_detail2 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL2',p_assignment_id,p_termination_date);
1968: lc_reason_detail3 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL3',p_assignment_id,p_termination_date);
1969: lc_reason_detail4 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL4',p_assignment_id,p_termination_date);
1970: lc_reason_detail5 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL5',p_assignment_id,p_termination_date);
1971: --
1972: lc_concrete_cir1 := lc_reason_detail||lc_reason_detail2||lc_reason_detail3;

Line 1969: lc_reason_detail4 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL4',p_assignment_id,p_termination_date);

1965: lc_term_reason := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','TRM_REASON',p_assignment_id,p_termination_date);
1966: lc_reason_detail := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL',p_assignment_id,p_termination_date);
1967: lc_reason_detail2 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL2',p_assignment_id,p_termination_date);
1968: lc_reason_detail3 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL3',p_assignment_id,p_termination_date);
1969: lc_reason_detail4 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL4',p_assignment_id,p_termination_date);
1970: lc_reason_detail5 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL5',p_assignment_id,p_termination_date);
1971: --
1972: lc_concrete_cir1 := lc_reason_detail||lc_reason_detail2||lc_reason_detail3;
1973: lc_concrete_cir2 := lc_reason_detail4||lc_reason_detail5;

Line 1970: lc_reason_detail5 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL5',p_assignment_id,p_termination_date);

1966: lc_reason_detail := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL',p_assignment_id,p_termination_date);
1967: lc_reason_detail2 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL2',p_assignment_id,p_termination_date);
1968: lc_reason_detail3 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL3',p_assignment_id,p_termination_date);
1969: lc_reason_detail4 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL4',p_assignment_id,p_termination_date);
1970: lc_reason_detail5 := pay_jp_balance_pkg.get_entry_value_char('COM_TRM_REPORT_REASON_INFO','DETAIL5',p_assignment_id,p_termination_date);
1971: --
1972: lc_concrete_cir1 := lc_reason_detail||lc_reason_detail2||lc_reason_detail3;
1973: lc_concrete_cir2 := lc_reason_detail4||lc_reason_detail5;
1974: --

Line 2209: gc_legislation_code := pay_jp_balance_pkg.get_legislation_code(gr_parameters.business_group_id);

2205: END IF;
2206: --
2207: gn_business_group_id := gr_parameters.business_group_id ;
2208: gn_payroll_action_id := p_payroll_action_id;
2209: gc_legislation_code := pay_jp_balance_pkg.get_legislation_code(gr_parameters.business_group_id);
2210: gn_sal_ele_set_id := get_element_set_id(gc_sal_ele_set,gr_parameters.business_group_id,gc_legislation_code);
2211: gn_spb_ele_set_id := get_element_set_id(gc_spb_ele_set,gr_parameters.business_group_id,gc_legislation_code);
2212: --
2213: -------------------------------------------------------------------------