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_CA_ROE_EI_PKG dependencies on PAY_BALANCE_TYPES

Line 417: pay_balance_types blt

413: pay_run_result_values rrv,
414: pay_element_types_f ele,
415: pay_input_values_f ipv,
416: pay_balance_feeds_f blf,
417: pay_balance_types blt
418: WHERE asa.assignment_id = p_asg_id
419: AND asa.tax_unit_id = p_gre
420: AND pya.payroll_id = p_payroll_id
421: AND pya.payroll_action_id = asa.payroll_action_id

Line 461: pay_balance_types blt

457: pay_run_result_values rrv,
458: pay_element_types_f ele,
459: pay_input_values_f ipv,
460: pay_balance_feeds_f blf,
461: pay_balance_types blt
462: WHERE asa.assignment_id = p_asg_id
463: AND asa.tax_unit_id = p_gre
464: AND pya.payroll_id = p_payroll_id
465: AND pya.payroll_action_id = asa.payroll_action_id

Line 501: pay_balance_types blt

497: pay_run_result_values rrv,
498: pay_element_types_f ele,
499: pay_input_values_f ipv,
500: pay_balance_feeds_f blf,
501: pay_balance_types blt
502: WHERE asa.assignment_id = p_asg_id
503: AND asa.tax_unit_id = p_gre
504: AND pya.payroll_id = p_payroll_id
505: AND pya.payroll_action_id = asa.payroll_action_id

Line 545: pay_balance_types blt

541: pay_run_result_values rrv,
542: pay_element_types_f ele,
543: pay_input_values_f ipv,
544: pay_balance_feeds_f blf,
545: pay_balance_types blt
546: WHERE asa.assignment_id = p_asg_id
547: AND asa.tax_unit_id = p_gre
548: AND pya.payroll_id = p_payroll_id
549: AND pya.payroll_action_id = asa.payroll_action_id

Line 695: pay_balance_types blt

691: pay_element_types_f ele,
692: pay_element_classifications elc,
693: pay_input_values_f ipv,
694: pay_balance_feeds_f blf,
695: pay_balance_types blt
696: WHERE asa.assignment_id = p_asg_id
697: AND asa.tax_unit_id = p_gre
698: AND pya.payroll_id = p_payroll_id
699: AND pya.payroll_action_id = asa.payroll_action_id

Line 851: pay_balance_types blt

847: pay_element_types_f ele,
848: pay_element_classifications elc,
849: pay_input_values_f ipv,
850: pay_balance_feeds_f blf,
851: pay_balance_types blt
852: WHERE asa.assignment_id = p_asg_id
853: AND asa.tax_unit_id = p_gre
854: AND pya.payroll_id = p_payroll_id
855: AND pya.payroll_action_id = asa.payroll_action_id

Line 1011: pay_balance_types blt

1007: pay_element_types_f ele,
1008: pay_element_classifications elc,
1009: pay_input_values_f ipv,
1010: pay_balance_feeds_f blf,
1011: pay_balance_types blt
1012: WHERE asa.assignment_id = p_asg_id
1013: AND asa.tax_unit_id = p_gre
1014: AND pya.payroll_id = p_payroll_id
1015: AND pya.payroll_action_id = asa.payroll_action_id

Line 1166: pay_balance_types blt

1162: pay_element_types_f ele,
1163: pay_element_classifications elc,
1164: pay_input_values_f ipv,
1165: pay_balance_feeds_f blf,
1166: pay_balance_types blt
1167: WHERE asa.assignment_id = p_asg_id
1168: AND asa.tax_unit_id = p_gre
1169: AND pya.payroll_id = p_payroll_id
1170: AND pya.payroll_action_id = asa.payroll_action_id

Line 2245: pay_balance_types pbt

2241: CURSOR cur_bal_type_id IS
2242: SELECT
2243: pbt.balance_type_id
2244: FROM
2245: pay_balance_types pbt
2246: WHERE
2247: pbt.balance_name = 'EI Hours' and
2248: pbt.legislation_code = 'CA';
2249:

Line 2250: l_bal_type_id pay_balance_types.balance_type_id%TYPE;

2246: WHERE
2247: pbt.balance_name = 'EI Hours' and
2248: pbt.legislation_code = 'CA';
2249:
2250: l_bal_type_id pay_balance_types.balance_type_id%TYPE;
2251:
2252: /* CURSOR csr_get_element_id (p_dp_or_de VARCHAR2)
2253: IS
2254: SELECT DISTINCT ele.element_type_id