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_SG_DEDUCTIONS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 760: p_assignment_id in pay_assignment_actions.assignment_id%TYPE,

756: */
757:
758: function which_retro_method
759: (
760: p_assignment_id in pay_assignment_actions.assignment_id%TYPE,
761: p_date_earned in pay_payroll_actions.date_earned%TYPE,
762: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE
763: ) return varchar2 IS
764:

Line 777: pay_assignment_actions paa,

773: c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE
774: ) is
775: select pet.element_name
776: from pay_element_entries_f pee,
777: pay_assignment_actions paa,
778: pay_payroll_actions ppa,
779: pay_element_sets pes,
780: pay_element_type_rules petr,
781: pay_element_types_f pet

Line 798: pay_assignment_actions paa,

794: and pet.legislation_code = 'SG'
795: union all
796: select pec.classification_name
797: from pay_element_entries_f pee,
798: pay_assignment_actions paa,
799: pay_payroll_actions ppa,
800: pay_element_sets pes,
801: pay_ele_classification_rules pecr,
802: pay_element_classifications pec

Line 907: p_assignment_id in pay_assignment_actions.assignment_id%TYPE,

903: -- Monthly ceiling of 5,500
904: ---------------------------------------------------------------------------
905: function get_prev_year_ord_ytd
906: (
907: p_assignment_id in pay_assignment_actions.assignment_id%TYPE,
908: p_date_earned in pay_payroll_actions.date_earned%TYPE
909: )
910: return number is
911: --

Line 913: c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

909: )
910: return number is
911: --
912: cursor c_tax_unit_id( c_assignment_id number,
913: c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
914: is
915: select paa.tax_unit_id
916: from pay_assignment_actions paa
917: where paa.assignment_id = c_assignment_id

Line 916: from pay_assignment_actions paa

912: cursor c_tax_unit_id( c_assignment_id number,
913: c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
914: is
915: select paa.tax_unit_id
916: from pay_assignment_actions paa
917: where paa.assignment_id = c_assignment_id
918: and paa.assignment_action_id = c_assignment_action_id;
919: --
920: --------------------------------------------------------------------

Line 932: pay_assignment_actions paa,

928: select max(paa.action_sequence),
929: to_number(to_char(ppa.effective_date,'MM')),
930: max(pas.person_id)
931: from per_assignments_f pas,
932: pay_assignment_actions paa,
933: pay_payroll_actions ppa
934: where (pas.person_id, paa.tax_unit_id)
935: IN (select pas1.person_id,
936: hsc1.segment1

Line 958: pay_assignment_actions paa,

954: select paa.assignment_action_id,
955: ppa.effective_date,
956: paa.assignment_id
957: from per_assignments_f pas,
958: pay_assignment_actions paa,
959: pay_payroll_actions ppa
960: where pas.person_id = c_person_id /* Bug 5298298 */
961: and paa.assignment_id = pas.assignment_id
962: and ppa.payroll_action_id = paa.payroll_action_id

Line 991: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

987: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
988: g_context_tab pay_balance_pkg.t_context_tab;
989: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
990: --
991: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
992: l_action_sequence pay_assignment_actions.action_sequence%TYPE;
993: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
994: l_person_id per_assignments_f.person_id%TYPE;
995: l_month number;

Line 992: l_action_sequence pay_assignment_actions.action_sequence%TYPE;

988: g_context_tab pay_balance_pkg.t_context_tab;
989: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
990: --
991: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
992: l_action_sequence pay_assignment_actions.action_sequence%TYPE;
993: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
994: l_person_id per_assignments_f.person_id%TYPE;
995: l_month number;
996: l_effective_date date;

Line 993: l_assignment_id pay_assignment_actions.assignment_id%TYPE;

989: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
990: --
991: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
992: l_action_sequence pay_assignment_actions.action_sequence%TYPE;
993: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
994: l_person_id per_assignments_f.person_id%TYPE;
995: l_month number;
996: l_effective_date date;
997: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

Line 997: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

993: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
994: l_person_id per_assignments_f.person_id%TYPE;
995: l_month number;
996: l_effective_date date;
997: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
998: l_defined_bal_id number;
999: l_prev_ord_ytd number;
1000: l_ord_mon_cap_amt number;
1001: l_retro_exist boolean := FALSE ;

Line 1092: p_assignment_id in pay_assignment_actions.assignment_id%TYPE,

1088: -- Monthly ceiling of 5,500
1089: ---------------------------------------------------------------------------
1090: function get_cur_year_ord_ytd
1091: (
1092: p_assignment_id in pay_assignment_actions.assignment_id%TYPE,
1093: p_date_earned in pay_payroll_actions.date_earned%TYPE
1094: )
1095: return number is
1096: --

Line 1098: c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

1094: )
1095: return number is
1096: --
1097: cursor c_tax_unit_id( c_assignment_id number,
1098: c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
1099: is
1100: select paa.tax_unit_id
1101: from pay_assignment_actions paa
1102: where paa.assignment_id = c_assignment_id

Line 1101: from pay_assignment_actions paa

1097: cursor c_tax_unit_id( c_assignment_id number,
1098: c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
1099: is
1100: select paa.tax_unit_id
1101: from pay_assignment_actions paa
1102: where paa.assignment_id = c_assignment_id
1103: and paa.assignment_action_id = c_assignment_action_id;
1104: --
1105: --------------------------------------------------------------------

Line 1117: pay_assignment_actions paa,

1113: select max(paa.action_sequence),
1114: to_number(to_char(ppa.effective_date,'MM')),
1115: max(pas.person_id)
1116: from per_assignments_f pas,
1117: pay_assignment_actions paa,
1118: pay_payroll_actions ppa
1119: where (pas.person_id, paa.tax_unit_id)
1120: IN (select pas1.person_id,
1121: hsc1.segment1

Line 1143: pay_assignment_actions paa,

1139: select paa.assignment_action_id,
1140: ppa.effective_date,
1141: pas.assignment_id
1142: from per_assignments_f pas,
1143: pay_assignment_actions paa,
1144: pay_payroll_actions ppa
1145: where pas.person_id = c_person_id /* Bug 5298298 */
1146: and paa.assignment_id = pas.assignment_id
1147: and ppa.payroll_action_id = paa.payroll_action_id

Line 1176: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

1172: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1173: g_context_tab pay_balance_pkg.t_context_tab;
1174: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1175: --
1176: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1177: l_action_sequence pay_assignment_actions.action_sequence%TYPE;
1178: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
1179: l_person_id per_assignments_f.person_id%TYPE;
1180: l_month number;

Line 1177: l_action_sequence pay_assignment_actions.action_sequence%TYPE;

1173: g_context_tab pay_balance_pkg.t_context_tab;
1174: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1175: --
1176: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1177: l_action_sequence pay_assignment_actions.action_sequence%TYPE;
1178: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
1179: l_person_id per_assignments_f.person_id%TYPE;
1180: l_month number;
1181: l_effective_date date;

Line 1178: l_assignment_id pay_assignment_actions.assignment_id%TYPE;

1174: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1175: --
1176: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1177: l_action_sequence pay_assignment_actions.action_sequence%TYPE;
1178: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
1179: l_person_id per_assignments_f.person_id%TYPE;
1180: l_month number;
1181: l_effective_date date;
1182: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

Line 1182: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

1178: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
1179: l_person_id per_assignments_f.person_id%TYPE;
1180: l_month number;
1181: l_effective_date date;
1182: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
1183: l_defined_bal_id number;
1184: l_cur_ord_ytd number;
1185: l_ord_mon_cap_amt number;
1186: l_retro_exist boolean := FALSE ;

Line 1270: function get_retro_earnings( p_assignment_id in pay_assignment_actions.assignment_id%TYPE,

1266: return l_cur_ord_ytd;
1267: --
1268: end get_cur_year_ord_ytd;
1269: --
1270: function get_retro_earnings( p_assignment_id in pay_assignment_actions.assignment_id%TYPE,
1271: p_date_earned in date ) return number
1272: is
1273: cursor c_pay_element_entries
1274: is

Line 1284: from pay_assignment_actions paa1,

1280: pay_element_classifications pec
1281: where pee.assignment_id = p_assignment_id
1282: and pee.source_asg_action_id in
1283: (select paa1.assignment_action_id
1284: from pay_assignment_actions paa1,
1285: pay_payroll_actions ppa1
1286: where paa1.assignment_id = pee.assignment_id
1287: and ppa1.payroll_action_id = paa1.payroll_action_id
1288: and ppa1.action_type in ('R','Q','B','V','I')