APPS.PAY_SG_DEDUCTIONS dependencies on PAY_ELEMENT_ENTRIES_F

Line 882: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

878: */
879:
880: function check_if_retro
881: (
882: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
883: p_date_earned in pay_payroll_actions.date_earned%TYPE
884: ) return varchar2 IS
885:
886: cursor c_get_creator_type(

Line 887: c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

883: p_date_earned in pay_payroll_actions.date_earned%TYPE
884: ) return varchar2 IS
885:
886: cursor c_get_creator_type(
887: c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
888: c_date_earned in pay_payroll_actions.date_earned%TYPE
889: ) is
890: SELECT creator_type
891: FROM pay_element_entries_f pee

Line 891: FROM pay_element_entries_f pee

887: c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
888: c_date_earned in pay_payroll_actions.date_earned%TYPE
889: ) is
890: SELECT creator_type
891: FROM pay_element_entries_f pee
892: WHERE pee.element_entry_id = c_element_entry_id
893: AND c_date_earned between pee.effective_start_date and pee.effective_end_date;
894:
895: l_creator_type pay_element_entries_f.creator_type%TYPE;

Line 895: l_creator_type pay_element_entries_f.creator_type%TYPE;

891: FROM pay_element_entries_f pee
892: WHERE pee.element_entry_id = c_element_entry_id
893: AND c_date_earned between pee.effective_start_date and pee.effective_end_date;
894:
895: l_creator_type pay_element_entries_f.creator_type%TYPE;
896: IS_retro_payment varchar2(10);
897:
898: begin
899:

Line 939: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE

935: function which_retro_method
936: (
937: p_assignment_id in pay_assignment_actions.assignment_id%TYPE,
938: p_date_earned in pay_payroll_actions.date_earned%TYPE,
939: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE
940: ) return varchar2 IS
941:
942: /*
943: ** Bug#5353558 Cursor to look for any CPF elements exists in the Element Set of

Line 948: ( c_assignment_id in pay_element_entries_f.element_entry_id%TYPE,

944: ** the retro pay, which has created this retro element.
945: */
946:
947: cursor get_retro_method
948: ( c_assignment_id in pay_element_entries_f.element_entry_id%TYPE,
949: c_date_earned in pay_payroll_actions.date_earned%TYPE,
950: c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE
951: ) is
952: select pet.element_name

Line 950: c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE

946:
947: cursor get_retro_method
948: ( c_assignment_id in pay_element_entries_f.element_entry_id%TYPE,
949: c_date_earned in pay_payroll_actions.date_earned%TYPE,
950: c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE
951: ) is
952: select pet.element_name
953: from pay_element_entries_f pee,
954: pay_assignment_actions paa,

Line 953: from pay_element_entries_f pee,

949: c_date_earned in pay_payroll_actions.date_earned%TYPE,
950: c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE
951: ) is
952: select pet.element_name
953: from pay_element_entries_f pee,
954: pay_assignment_actions paa,
955: pay_payroll_actions ppa,
956: pay_element_sets pes,
957: pay_element_type_rules petr,

Line 974: from pay_element_entries_f pee,

970: and pet.element_name like '%CPF%'
971: and pet.legislation_code = 'SG'
972: union all
973: select pec.classification_name
974: from pay_element_entries_f pee,
975: pay_assignment_actions paa,
976: pay_payroll_actions ppa,
977: pay_element_sets pes,
978: pay_ele_classification_rules pecr,

Line 1504: pay_element_entries_f pee,

1500: cursor c_pay_element_entries
1501: is
1502: select sum(peev.screen_entry_value)
1503: from pay_element_entry_values_f peev,
1504: pay_element_entries_f pee,
1505: pay_element_types_f pet,
1506: pay_input_values_f piv,
1507: pay_element_classifications pec
1508: where pee.assignment_id = p_assignment_id